APPS.HZ_PURGE_GEN dependencies on PON_TE_RECIPIENTS

Line 1898: exists (select 'Y' from PON_TE_RECIPIENTS xx where xx.TO_ID = temp.party_id

1894: if(regid_proc = true) then
1895: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where
1896:
1897:
1898: exists (select 'Y' from PON_TE_RECIPIENTS xx where xx.TO_ID = temp.party_id
1899: )
1900:
1901: or exists (select 'Y' from PON_BIDDING_PARTIES xx where xx.TRADING_PARTNER_ID = temp.party_id
1902: )

Line 1937: exists (select 'Y' from PON_TE_RECIPIENTS xx where xx.TO_ID = temp.party_id

1933: else
1934: delete from hz_purge_gt temp where
1935:
1936:
1937: exists (select 'Y' from PON_TE_RECIPIENTS xx where xx.TO_ID = temp.party_id
1938: )
1939:
1940: or exists (select 'Y' from PON_BIDDING_PARTIES xx where xx.TRADING_PARTNER_ID = temp.party_id
1941: )

Line 4276: --PON_TE_RECIPIENTS;TO_COMPANY_ID

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;
4278: if(regid_proc = true) then
4279: 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
4280:

Line 4281: temp.party_id in (select /*+ parallel(xx)*/ xx.TO_COMPANY_ID from PON_TE_RECIPIENTS xx

4277: appid:=396;
4278: if(regid_proc = true) then
4279: 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
4280:
4281: temp.party_id in (select /*+ parallel(xx)*/ xx.TO_COMPANY_ID from PON_TE_RECIPIENTS xx
4282: );
4283: else
4284: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4285: temp.party_id in (select /*+ parallel(xx)*/ xx.TO_COMPANY_ID from PON_TE_RECIPIENTS xx

Line 4285: temp.party_id in (select /*+ parallel(xx)*/ xx.TO_COMPANY_ID from PON_TE_RECIPIENTS xx

4281: temp.party_id in (select /*+ parallel(xx)*/ xx.TO_COMPANY_ID from PON_TE_RECIPIENTS xx
4282: );
4283: else
4284: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4285: temp.party_id in (select /*+ parallel(xx)*/ xx.TO_COMPANY_ID from PON_TE_RECIPIENTS xx
4286: );
4287: end if;
4288: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_CONTACT_ID
4289: appid:=396;