APPS.HZ_PURGE_GEN dependencies on PON_THREADS

Line 4140: --PON_THREADS;OWNER_PARTY_ID

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;
4142: if(regid_proc = true) then
4143: 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
4144:

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

4141: appid:=396;
4142: if(regid_proc = true) then
4143: 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
4144:
4145: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx
4146: );
4147: else
4148: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4149: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx

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

4145: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx
4146: );
4147: else
4148: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4149: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx
4150: );
4151: end if;
4152: --PON_THREAD_ENTRIES;FROM_ID
4153: appid:=396;