APPS.HZ_PURGE_GEN dependencies on PON_AUCTION_SUMMARY

Line 4396: --PON_AUCTION_SUMMARY;TRADING_PARTNER_CONTACT_ID

4392: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4393: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx
4394: );
4395: end if;
4396: --PON_AUCTION_SUMMARY;TRADING_PARTNER_CONTACT_ID
4397: appid:=396;
4398: if(regid_proc = true) then
4399: 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
4400:

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

4397: appid:=396;
4398: if(regid_proc = true) then
4399: 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
4400:
4401: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx
4402: );
4403: else
4404: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4405: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx

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

4401: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx
4402: );
4403: else
4404: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4405: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx
4406: );
4407: end if;
4408: --PON_AUCTION_SUMMARY;TRADING_PARTNER_ID
4409: appid:=396;

Line 4408: --PON_AUCTION_SUMMARY;TRADING_PARTNER_ID

4404: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4405: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx
4406: );
4407: end if;
4408: --PON_AUCTION_SUMMARY;TRADING_PARTNER_ID
4409: appid:=396;
4410: if(regid_proc = true) then
4411: 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
4412:

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

4409: appid:=396;
4410: if(regid_proc = true) then
4411: 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
4412:
4413: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx
4414: );
4415: else
4416: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4417: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx

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

4413: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx
4414: );
4415: else
4416: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4417: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx
4418: );
4419: end if;
4420: --PON_SUPPLIER_ACTIVITIES;TRADING_PARTNER_CONTACT_ID
4421: appid:=396;