APPS.HZ_PURGE_GEN dependencies on AMW_VIOLATIONS

Line 4108: --AMW_VIOLATIONS;REQUESTED_BY_ID

4104: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4105: temp.party_id in (select /*+ parallel(xx)*/ xx.ENTERED_BY_ID from AMW_CONSTRAINTS_B xx
4106: );
4107: end if;
4108: --AMW_VIOLATIONS;REQUESTED_BY_ID
4109: appid:=242;
4110: if(regid_proc = true) then
4111: 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
4112:

Line 4113: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_ID from AMW_VIOLATIONS xx

4109: appid:=242;
4110: if(regid_proc = true) then
4111: 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
4112:
4113: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_ID from AMW_VIOLATIONS xx
4114: );
4115: else
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

Line 4117: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_ID from AMW_VIOLATIONS xx

4113: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_ID from AMW_VIOLATIONS xx
4114: );
4115: else
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;