APPS.HZ_PURGE_GEN dependencies on PON_AUCTION_EVENTS

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

1821:
1822: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1823: )
1824:
1825: or exists (select 'Y' from PON_AUCTION_EVENTS xx where xx.TRADING_PARTNER_ID = temp.party_id
1826: )
1827:
1828: or exists (select 'Y' from PON_BIDDERS_LISTS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1829: )

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

1857:
1858: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1859: )
1860:
1861: or exists (select 'Y' from PON_AUCTION_EVENTS xx where xx.TRADING_PARTNER_ID = temp.party_id
1862: )
1863:
1864: or exists (select 'Y' from PON_BIDDERS_LISTS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1865: )

Line 4380: --PON_AUCTION_EVENTS;TRADING_PARTNER_CONTACT_ID

4376: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4377: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_HEADERS_ALL xx
4378: );
4379: end if;
4380: --PON_AUCTION_EVENTS;TRADING_PARTNER_CONTACT_ID
4381: appid:=396;
4382: if(regid_proc = true) then
4383: 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
4384:

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

4381: appid:=396;
4382: if(regid_proc = true) then
4383: 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
4384:
4385: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx
4386: );
4387: else
4388: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4389: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx

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

4385: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx
4386: );
4387: else
4388: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4389: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx
4390: );
4391: end if;
4392: --PON_BID_HEADERS;SURROG_BID_CREATED_CONTACT_ID
4393: appid:=396;