APPS.HZ_PURGE_GEN dependencies on PON_OPTIMIZE_CONSTRAINTS

Line 4348: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_CONTACT_ID

4344: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4345: temp.party_id in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4346: );
4347: end if;
4348: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_CONTACT_ID
4349: appid:=396;
4350: if(regid_proc = true) then
4351: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4352:

Line 4353: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx

4349: appid:=396;
4350: if(regid_proc = true) then
4351: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4352:
4353: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx
4354: );
4355: else
4356: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4357: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx

Line 4357: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx

4353: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx
4354: );
4355: else
4356: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4357: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx
4358: );
4359: end if;
4360: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_ID
4361: appid:=396;

Line 4360: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_ID

4356: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4357: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx
4358: );
4359: end if;
4360: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_ID
4361: appid:=396;
4362: if(regid_proc = true) then
4363: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4364:

Line 4365: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx

4361: appid:=396;
4362: if(regid_proc = true) then
4363: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4364:
4365: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx
4366: );
4367: else
4368: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4369: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx

Line 4369: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx

4365: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx
4366: );
4367: else
4368: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4369: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx
4370: );
4371: end if;
4372: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_CONTACT_ID
4373: appid:=396;