APPS.HZ_PURGE_GEN dependencies on PON_THREAD_ENTRIES

Line 4252: --PON_THREAD_ENTRIES;FROM_ID

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;
4254: if(regid_proc = true) then
4255: 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
4256:

Line 4257: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_ID from PON_THREAD_ENTRIES xx

4253: appid:=396;
4254: if(regid_proc = true) then
4255: 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
4256:
4257: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_ID from PON_THREAD_ENTRIES xx
4258: );
4259: else
4260: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4261: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_ID from PON_THREAD_ENTRIES xx

Line 4261: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_ID from PON_THREAD_ENTRIES xx

4257: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_ID from PON_THREAD_ENTRIES xx
4258: );
4259: else
4260: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4261: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_ID from PON_THREAD_ENTRIES xx
4262: );
4263: end if;
4264: --PON_THREAD_ENTRIES;FROM_COMPANY_ID
4265: appid:=396;

Line 4264: --PON_THREAD_ENTRIES;FROM_COMPANY_ID

4260: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4261: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_ID from PON_THREAD_ENTRIES xx
4262: );
4263: end if;
4264: --PON_THREAD_ENTRIES;FROM_COMPANY_ID
4265: appid:=396;
4266: if(regid_proc = true) then
4267: 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
4268:

Line 4269: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_COMPANY_ID from PON_THREAD_ENTRIES xx

4265: appid:=396;
4266: if(regid_proc = true) then
4267: 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
4268:
4269: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_COMPANY_ID from PON_THREAD_ENTRIES xx
4270: );
4271: else
4272: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4273: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_COMPANY_ID from PON_THREAD_ENTRIES xx

Line 4273: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_COMPANY_ID from PON_THREAD_ENTRIES xx

4269: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_COMPANY_ID from PON_THREAD_ENTRIES xx
4270: );
4271: else
4272: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4273: temp.party_id in (select /*+ parallel(xx)*/ xx.FROM_COMPANY_ID from PON_THREAD_ENTRIES xx
4274: );
4275: end if;
4276: --PON_TE_RECIPIENTS;TO_COMPANY_ID
4277: appid:=396;