APPS.HZ_PURGE_GEN dependencies on PON_CONTRACTS

Line 4216: --PON_CONTRACTS;AUTHORING_PARTY_CONTACT_ID

4212: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4213: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx
4214: );
4215: end if;
4216: --PON_CONTRACTS;AUTHORING_PARTY_CONTACT_ID
4217: appid:=396;
4218: if(regid_proc = true) then
4219: 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
4220:

Line 4221: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx

4217: appid:=396;
4218: if(regid_proc = true) then
4219: 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
4220:
4221: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx
4222: );
4223: else
4224: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4225: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx

Line 4225: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx

4221: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx
4222: );
4223: else
4224: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4225: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx
4226: );
4227: end if;
4228: --PON_CONTRACTS;AUTHORING_PARTY_ID
4229: appid:=396;

Line 4228: --PON_CONTRACTS;AUTHORING_PARTY_ID

4224: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4225: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx
4226: );
4227: end if;
4228: --PON_CONTRACTS;AUTHORING_PARTY_ID
4229: appid:=396;
4230: if(regid_proc = true) then
4231: 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
4232:

Line 4233: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx

4229: appid:=396;
4230: if(regid_proc = true) then
4231: 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
4232:
4233: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx
4234: );
4235: else
4236: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4237: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx

Line 4237: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx

4233: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx
4234: );
4235: else
4236: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4237: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx
4238: );
4239: end if;
4240: --PON_THREADS;OWNER_PARTY_ID
4241: appid:=396;