APPS.HZ_PURGE_GEN dependencies on PON_CONTRACTS

Line 4116: --PON_CONTRACTS;AUTHORING_PARTY_CONTACT_ID

4112: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4113: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx
4114: );
4115: end if;
4116: --PON_CONTRACTS;AUTHORING_PARTY_CONTACT_ID
4117: appid:=396;
4118: if(regid_proc = true) then
4119: 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
4120:

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

4117: appid:=396;
4118: if(regid_proc = true) then
4119: 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
4120:
4121: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx
4122: );
4123: else
4124: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4125: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx

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

4121: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx
4122: );
4123: else
4124: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4125: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx
4126: );
4127: end if;
4128: --PON_CONTRACTS;AUTHORING_PARTY_ID
4129: appid:=396;

Line 4128: --PON_CONTRACTS;AUTHORING_PARTY_ID

4124: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4125: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx
4126: );
4127: end if;
4128: --PON_CONTRACTS;AUTHORING_PARTY_ID
4129: appid:=396;
4130: if(regid_proc = true) then
4131: 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
4132:

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

4129: appid:=396;
4130: if(regid_proc = true) then
4131: 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
4132:
4133: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx
4134: );
4135: else
4136: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4137: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx

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

4133: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx
4134: );
4135: else
4136: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4137: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx
4138: );
4139: end if;
4140: --PON_THREADS;OWNER_PARTY_ID
4141: appid:=396;