APPS.HZ_PURGE_GEN dependencies on OKL_INS_POLICIES_B

Line 4486: --OKL_INS_POLICIES_B;AGENCY_SITE_ID

4482: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_ALL_B
4483: yy
4484: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4485: end if;
4486: --OKL_INS_POLICIES_B;AGENCY_SITE_ID
4487: appid:=540;
4488: if(regid_proc = true) then
4489: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4490:

Line 4495: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B

4491: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4492: xx
4493: where (nvl(STATUS, 'A') in ('A','I'))
4494: and xx.PARTY_SITE_ID
4495: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
4496: yy
4497: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4498: else
4499: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4504: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B

4500: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4501: xx
4502: where (nvl(STATUS, 'A') in ('A','I'))
4503: and xx.PARTY_SITE_ID
4504: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
4505: yy
4506: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4507: end if;
4508: --OKL_INS_POLICIES_ALL_B;AGENCY_SITE_ID