APPS.HZ_PURGE_GEN dependencies on PON_AUCTION_EVENTS

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

1909:
1910: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_ID = temp.party_id
1911: )
1912:
1913: or exists (select 'Y' from PON_AUCTION_EVENTS xx where xx.TRADING_PARTNER_ID = temp.party_id
1914: )
1915:
1916: or exists (select 'Y' from PON_BIDDERS_LISTS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1917: )

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

1948:
1949: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_ID = temp.party_id
1950: )
1951:
1952: or exists (select 'Y' from PON_AUCTION_EVENTS xx where xx.TRADING_PARTNER_ID = temp.party_id
1953: )
1954:
1955: or exists (select 'Y' from PON_BIDDERS_LISTS xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1956: )

Line 4468: --PON_AUCTION_EVENTS;TRADING_PARTNER_CONTACT_ID

4464: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4465: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORING_LOCK_TP_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4466: );
4467: end if;
4468: --PON_AUCTION_EVENTS;TRADING_PARTNER_CONTACT_ID
4469: appid:=396;
4470: if(regid_proc = true) then
4471: 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
4472:

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

4469: appid:=396;
4470: if(regid_proc = true) then
4471: 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
4472:
4473: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx
4474: );
4475: else
4476: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4477: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx

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

4473: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx
4474: );
4475: else
4476: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4477: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx
4478: );
4479: end if;
4480: --PON_BID_HEADERS;SURROG_BID_CREATED_CONTACT_ID
4481: appid:=396;