Using PUM package name to get the list of objects modified PeopleSoft PUM :

 Using PUM  package name to get the list of objects modified PeopleSoft PUM :

select distinct ptiasprptno,objecttype,descr254,objectid1,objectvalue1,objectid2,objectvalue2,objectid3,objectvalue3,
objectid4,objectvalue4 from
PS_PTIASPRPTMOLVW where ptiasprptno in (select distinct ptiasprptno from PS_PTIASPPKGBUGS where
ptiasppkgname='IMAGE_1417')
group by  ptiasprptno,objecttype,descr254,objectid1,objectvalue1,objectid2,objectvalue2,objectid3,objectvalue3,objectid4,objectvalue4;