APPS.HZ_PURGE_GEN dependencies on OKE_POOL_PARTIES

Line 3930: --OKE_POOL_PARTIES;PARTY_ID

3926: in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
3927: yy
3928: ));
3929: end if;
3930: --OKE_POOL_PARTIES;PARTY_ID
3931: appid:=777;
3932: if(regid_proc = true) then
3933: 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
3934:

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

3931: appid:=777;
3932: if(regid_proc = true) then
3933: 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
3934:
3935: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx
3936: );
3937: else
3938: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3939: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx

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

3935: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx
3936: );
3937: else
3938: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3939: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx
3940: );
3941: end if;
3942: --AHL_SUBSCRIPTIONS_B;REQUESTED_BY_PARTY_ID
3943: appid:=867;