APPS.HZ_PURGE_GEN dependencies on OKE_POOL_PARTIES

Line 3890: --OKE_POOL_PARTIES;PARTY_ID

3886: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3887: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx
3888: );
3889: end if;
3890: --OKE_POOL_PARTIES;PARTY_ID
3891: appid:=777;
3892: if(regid_proc = true) then
3893: insert into hz_application_trans_gt(app_id,party_id) select 777, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 777 and appl.party_id=temp.party_id) and
3894:

Line 3895: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx

3891: appid:=777;
3892: if(regid_proc = true) then
3893: insert into hz_application_trans_gt(app_id,party_id) select 777, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 777 and appl.party_id=temp.party_id) and
3894:
3895: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx
3896: );
3897: else
3898: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3899: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx

Line 3899: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx

3895: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx
3896: );
3897: else
3898: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3899: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx
3900: );
3901: end if;
3902: --AHL_SUBSCRIPTIONS_B;REQUESTED_BY_PARTY_ID
3903: appid:=867;