APPS.HZ_PURGE_GEN dependencies on OKL_INS_POLICIES_ALL_B

Line 4452: --OKL_INS_POLICIES_ALL_B;INT_ID

4448: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4449: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4450: );
4451: end if;
4452: --OKL_INS_POLICIES_ALL_B;INT_ID
4453: appid:=540;
4454: if(regid_proc = true) then
4455: 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
4456:

Line 4457: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_ALL_B xx

4453: appid:=540;
4454: if(regid_proc = true) then
4455: 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
4456:
4457: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_ALL_B xx
4458: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4459: else
4460: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4461: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_ALL_B xx

Line 4461: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_ALL_B xx

4457: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_ALL_B xx
4458: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4459: else
4460: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4461: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_ALL_B xx
4462: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4463: end if;
4464: --OKL_INS_POLICIES_ALL_B;AGENT_SITE_ID
4465: appid:=540;

Line 4464: --OKL_INS_POLICIES_ALL_B;AGENT_SITE_ID

4460: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4461: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_ALL_B xx
4462: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4463: end if;
4464: --OKL_INS_POLICIES_ALL_B;AGENT_SITE_ID
4465: appid:=540;
4466: if(regid_proc = true) then
4467: 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
4468:

Line 4473: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_ALL_B

4469: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4470: xx
4471: where (nvl(STATUS, 'A') in ('A','I'))
4472: and to_char(xx.PARTY_SITE_ID)
4473: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_ALL_B
4474: yy
4475: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4476: else
4477: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4482: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_ALL_B

4478: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4479: xx
4480: where (nvl(STATUS, 'A') in ('A','I'))
4481: and to_char(xx.PARTY_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

Line 4508: --OKL_INS_POLICIES_ALL_B;AGENCY_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
4509: appid:=540;
4510: if(regid_proc = true) then
4511: 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
4512:

Line 4517: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_ALL_B

4513: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4514: xx
4515: where (nvl(STATUS, 'A') in ('A','I'))
4516: and xx.PARTY_SITE_ID
4517: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_ALL_B
4518: yy
4519: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4520: else
4521: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4526: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_ALL_B

4522: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4523: xx
4524: where (nvl(STATUS, 'A') in ('A','I'))
4525: and xx.PARTY_SITE_ID
4526: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_ALL_B
4527: yy
4528: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4529: end if;
4530: --OKL_INS_POLICIES_ALL_B;ISU_ID

Line 4530: --OKL_INS_POLICIES_ALL_B;ISU_ID

4526: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_ALL_B
4527: yy
4528: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4529: end if;
4530: --OKL_INS_POLICIES_ALL_B;ISU_ID
4531: appid:=540;
4532: if(regid_proc = true) then
4533: 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
4534:

Line 4535: temp.party_id in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_ALL_B xx

4531: appid:=540;
4532: if(regid_proc = true) then
4533: 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
4534:
4535: temp.party_id in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_ALL_B xx
4536: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4537: else
4538: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4539: temp.party_id in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_ALL_B xx

Line 4539: temp.party_id in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_ALL_B xx

4535: temp.party_id in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_ALL_B xx
4536: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4537: else
4538: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4539: temp.party_id in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_ALL_B xx
4540: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4541: end if;
4542: --OKC_K_PARTY_ROLES_B;OBJECT1_ID1
4543: appid:=540;