APPS.HZ_PURGE_GEN dependencies on PON_AUCTION_SUMMARY

Line 4296: --PON_AUCTION_SUMMARY;TRADING_PARTNER_CONTACT_ID

4292: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4293: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx
4294: );
4295: end if;
4296: --PON_AUCTION_SUMMARY;TRADING_PARTNER_CONTACT_ID
4297: appid:=396;
4298: if(regid_proc = true) then
4299: 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
4300:

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

4297: appid:=396;
4298: if(regid_proc = true) then
4299: 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
4300:
4301: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx
4302: );
4303: else
4304: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4305: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx

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

4301: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx
4302: );
4303: else
4304: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4305: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx
4306: );
4307: end if;
4308: --PON_AUCTION_SUMMARY;TRADING_PARTNER_ID
4309: appid:=396;

Line 4308: --PON_AUCTION_SUMMARY;TRADING_PARTNER_ID

4304: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4305: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx
4306: );
4307: end if;
4308: --PON_AUCTION_SUMMARY;TRADING_PARTNER_ID
4309: appid:=396;
4310: if(regid_proc = true) then
4311: 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
4312:

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

4309: appid:=396;
4310: if(regid_proc = true) then
4311: 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
4312:
4313: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx
4314: );
4315: else
4316: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4317: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx

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

4313: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx
4314: );
4315: else
4316: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4317: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx
4318: );
4319: end if;
4320: --PON_SUPPLIER_ACTIVITIES;TRADING_PARTNER_CONTACT_ID
4321: appid:=396;