APPS.HZ_PURGE_GEN dependencies on PON_THREADS

Line 4240: --PON_THREADS;OWNER_PARTY_ID

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;
4242: if(regid_proc = true) then
4243: 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
4244:

Line 4245: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx

4241: appid:=396;
4242: if(regid_proc = true) then
4243: 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
4244:
4245: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx
4246: );
4247: else
4248: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4249: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx

Line 4249: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx

4245: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx
4246: );
4247: else
4248: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4249: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx
4250: );
4251: end if;
4252: --PON_THREAD_ENTRIES;FROM_ID
4253: appid:=396;