APPS.HZ_PURGE_GEN dependencies on AMW_CERTIFICATION_B

Line 4120: --AMW_CERTIFICATION_B;CERTIFICATION_OWNER_ID

4116: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4117: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_ID from AMW_VIOLATIONS xx
4118: );
4119: end if;
4120: --AMW_CERTIFICATION_B;CERTIFICATION_OWNER_ID
4121: appid:=242;
4122: if(regid_proc = true) then
4123: insert into hz_application_trans_gt(app_id,party_id) select 242, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 242 and appl.party_id=temp.party_id) and
4124:

Line 4125: temp.party_id in (select /*+ parallel(xx)*/ xx.CERTIFICATION_OWNER_ID from AMW_CERTIFICATION_B xx

4121: appid:=242;
4122: if(regid_proc = true) then
4123: insert into hz_application_trans_gt(app_id,party_id) select 242, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 242 and appl.party_id=temp.party_id) and
4124:
4125: temp.party_id in (select /*+ parallel(xx)*/ xx.CERTIFICATION_OWNER_ID from AMW_CERTIFICATION_B xx
4126: );
4127: else
4128: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4129: temp.party_id in (select /*+ parallel(xx)*/ xx.CERTIFICATION_OWNER_ID from AMW_CERTIFICATION_B xx

Line 4129: temp.party_id in (select /*+ parallel(xx)*/ xx.CERTIFICATION_OWNER_ID from AMW_CERTIFICATION_B xx

4125: temp.party_id in (select /*+ parallel(xx)*/ xx.CERTIFICATION_OWNER_ID from AMW_CERTIFICATION_B xx
4126: );
4127: else
4128: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4129: temp.party_id in (select /*+ parallel(xx)*/ xx.CERTIFICATION_OWNER_ID from AMW_CERTIFICATION_B xx
4130: );
4131: end if;
4132: --JTF_PERZ_DATA_V;ATTRIBUTE_VALUE
4133: appid:=514;