APPS.HZ_PURGE_GEN dependencies on PON_BIDDING_PARTIES

Line 1816: or exists (select 'Y' from PON_BIDDING_PARTIES xx where xx.TRADING_PARTNER_ID = temp.party_id

1812:
1813: exists (select 'Y' from PON_TE_RECIPIENTS xx where xx.TO_ID = temp.party_id
1814: )
1815:
1816: or exists (select 'Y' from PON_BIDDING_PARTIES xx where xx.TRADING_PARTNER_ID = temp.party_id
1817: )
1818:
1819: or exists (select 'Y' from PON_BID_ITEM_PRICES xx where xx.BID_TRADING_PARTNER_ID = temp.party_id
1820: )

Line 1852: or exists (select 'Y' from PON_BIDDING_PARTIES xx where xx.TRADING_PARTNER_ID = temp.party_id

1848:
1849: exists (select 'Y' from PON_TE_RECIPIENTS xx where xx.TO_ID = temp.party_id
1850: )
1851:
1852: or exists (select 'Y' from PON_BIDDING_PARTIES xx where xx.TRADING_PARTNER_ID = temp.party_id
1853: )
1854:
1855: or exists (select 'Y' from PON_BID_ITEM_PRICES xx where xx.BID_TRADING_PARTNER_ID = temp.party_id
1856: )

Line 4224: --PON_BIDDING_PARTIES;TRADING_PARTNER_CONTACT_ID

4220: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4221: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx
4222: );
4223: end if;
4224: --PON_BIDDING_PARTIES;TRADING_PARTNER_CONTACT_ID
4225: appid:=396;
4226: if(regid_proc = true) then
4227: 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
4228:

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

4225: appid:=396;
4226: if(regid_proc = true) then
4227: 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
4228:
4229: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4230: );
4231: else
4232: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4233: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx

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

4229: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4230: );
4231: else
4232: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4233: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4234: );
4235: end if;
4236: --PON_BIDDING_PARTIES;ACK_PARTNER_CONTACT_ID
4237: appid:=396;

Line 4236: --PON_BIDDING_PARTIES;ACK_PARTNER_CONTACT_ID

4232: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4233: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4234: );
4235: end if;
4236: --PON_BIDDING_PARTIES;ACK_PARTNER_CONTACT_ID
4237: appid:=396;
4238: if(regid_proc = true) then
4239: 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
4240:

Line 4241: temp.party_id in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx

4237: appid:=396;
4238: if(regid_proc = true) then
4239: 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
4240:
4241: temp.party_id in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4242: );
4243: else
4244: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4245: temp.party_id in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx

Line 4245: temp.party_id in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx

4241: temp.party_id in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4242: );
4243: else
4244: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4245: temp.party_id in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4246: );
4247: end if;
4248: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_CONTACT_ID
4249: appid:=396;