查找更改的PeopleCode

SELECT *
  FROM PSPCMPROG A
 WHERE LASTUPDOPRID = ‘&OPRID‘
   AND LASTUPDDTTM > (sysdate - 30)--一个月内，可自定义周期
   AND NOT EXISTS (SELECT ‘X‘
          FROM PSPROJECTITEM X
         WHERE X.PROJECTNAME = ‘&PROJECT‘
           AND X.OBJECTID1 = A.OBJECTID1
           AND X.OBJECTVALUE1 = A.OBJECTVALUE1
           AND X.OBJECTID2 = A.OBJECTID2
           AND X.OBJECTVALUE2 = A.OBJECTVALUE2
           AND X.OBJECTID3 = A.OBJECTID3
           AND X.OBJECTVALUE3 = A.OBJECTVALUE3
           AND X.OBJECTID4 = A.OBJECTID4
           AND X.OBJECTVALUE4 = A.OBJECTVALUE4);