APPS.HZ_PURGE_GEN dependencies on AMW_CONSTRAINTS_B

Line 4096: --AMW_CONSTRAINTS_B;ENTERED_BY_ID

4092: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4093: temp.party_id in (select /*+ parallel(xx)*/ xx.EXECUTED_BY from AMW_AP_EXECUTIONS xx
4094: );
4095: end if;
4096: --AMW_CONSTRAINTS_B;ENTERED_BY_ID
4097: appid:=242;
4098: if(regid_proc = true) then
4099: 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
4100:

Line 4101: temp.party_id in (select /*+ parallel(xx)*/ xx.ENTERED_BY_ID from AMW_CONSTRAINTS_B xx

4097: appid:=242;
4098: if(regid_proc = true) then
4099: 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
4100:
4101: temp.party_id in (select /*+ parallel(xx)*/ xx.ENTERED_BY_ID from AMW_CONSTRAINTS_B xx
4102: );
4103: else
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

Line 4105: temp.party_id in (select /*+ parallel(xx)*/ xx.ENTERED_BY_ID from AMW_CONSTRAINTS_B xx

4101: temp.party_id in (select /*+ parallel(xx)*/ xx.ENTERED_BY_ID from AMW_CONSTRAINTS_B xx
4102: );
4103: else
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;