APPS.HZ_PURGE_GEN dependencies on PON_BIDDING_PARTIES

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

1897:
1898: exists (select 'Y' from PON_TE_RECIPIENTS xx where xx.TO_ID = temp.party_id
1899: )
1900:
1901: or exists (select 'Y' from PON_BIDDING_PARTIES xx where xx.TRADING_PARTNER_ID = temp.party_id
1902: )
1903:
1904: or exists (select 'Y' from PON_BID_ITEM_PRICES xx where xx.BID_TRADING_PARTNER_ID = temp.party_id
1905: )

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

1936:
1937: exists (select 'Y' from PON_TE_RECIPIENTS xx where xx.TO_ID = temp.party_id
1938: )
1939:
1940: or exists (select 'Y' from PON_BIDDING_PARTIES xx where xx.TRADING_PARTNER_ID = temp.party_id
1941: )
1942:
1943: or exists (select 'Y' from PON_BID_ITEM_PRICES xx where xx.BID_TRADING_PARTNER_ID = temp.party_id
1944: )

Line 4324: --PON_BIDDING_PARTIES;TRADING_PARTNER_CONTACT_ID

4320: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4321: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx
4322: );
4323: end if;
4324: --PON_BIDDING_PARTIES;TRADING_PARTNER_CONTACT_ID
4325: appid:=396;
4326: if(regid_proc = true) then
4327: 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
4328:

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

4325: appid:=396;
4326: if(regid_proc = true) then
4327: 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
4328:
4329: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4330: );
4331: else
4332: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4333: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx

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

4329: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4330: );
4331: else
4332: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4333: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4334: );
4335: end if;
4336: --PON_BIDDING_PARTIES;ACK_PARTNER_CONTACT_ID
4337: appid:=396;

Line 4336: --PON_BIDDING_PARTIES;ACK_PARTNER_CONTACT_ID

4332: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4333: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4334: );
4335: end if;
4336: --PON_BIDDING_PARTIES;ACK_PARTNER_CONTACT_ID
4337: appid:=396;
4338: if(regid_proc = true) then
4339: 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
4340:

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

4337: appid:=396;
4338: if(regid_proc = true) then
4339: 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
4340:
4341: temp.party_id in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4342: );
4343: else
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

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

4341: temp.party_id in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4342: );
4343: else
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;