APPS.HZ_PURGE_GEN dependencies on OKL_INS_POLICIES_B

Line 4540: --OKL_INS_POLICIES_B;INT_ID

4536: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4537: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx
4538: );
4539: end if;
4540: --OKL_INS_POLICIES_B;INT_ID
4541: appid:=540;
4542: if(regid_proc = true) then
4543: 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
4544:

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

4541: appid:=540;
4542: if(regid_proc = true) then
4543: 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
4544:
4545: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_B xx
4546: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4547: else
4548: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4549: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_B xx

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

4545: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_B xx
4546: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4547: else
4548: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4549: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_B xx
4550: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4551: end if;
4552: --OKL_INS_POLICIES_B;AGENT_SITE_ID
4553: appid:=540;

Line 4552: --OKL_INS_POLICIES_B;AGENT_SITE_ID

4548: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4549: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_B xx
4550: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4551: end if;
4552: --OKL_INS_POLICIES_B;AGENT_SITE_ID
4553: appid:=540;
4554: if(regid_proc = true) then
4555: 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
4556:

Line 4561: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_B

4557: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4558: xx
4559: where (nvl(STATUS, 'A') in ('A','I'))
4560: and to_char(xx.PARTY_SITE_ID)
4561: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_B
4562: yy
4563: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4564: else
4565: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4570: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_B

4566: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4567: xx
4568: where (nvl(STATUS, 'A') in ('A','I'))
4569: and to_char(xx.PARTY_SITE_ID)
4570: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_B
4571: yy
4572: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4573: end if;
4574: --OKL_INS_POLICIES_B;AGENCY_SITE_ID

Line 4574: --OKL_INS_POLICIES_B;AGENCY_SITE_ID

4570: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_B
4571: yy
4572: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4573: end if;
4574: --OKL_INS_POLICIES_B;AGENCY_SITE_ID
4575: appid:=540;
4576: if(regid_proc = true) then
4577: 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
4578:

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

4579: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4580: xx
4581: where (nvl(STATUS, 'A') in ('A','I'))
4582: and xx.PARTY_SITE_ID
4583: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
4584: yy
4585: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4586: else
4587: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

4588: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4589: xx
4590: where (nvl(STATUS, 'A') in ('A','I'))
4591: and xx.PARTY_SITE_ID
4592: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
4593: yy
4594: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4595: end if;
4596: --OKL_INS_POLICIES_B;AGENCY_SITE_ID

Line 4596: --OKL_INS_POLICIES_B;AGENCY_SITE_ID

4592: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
4593: yy
4594: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4595: end if;
4596: --OKL_INS_POLICIES_B;AGENCY_SITE_ID
4597: appid:=540;
4598: if(regid_proc = true) then
4599: 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
4600:

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

4601: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4602: xx
4603: where (nvl(STATUS, 'A') in ('A','I'))
4604: and xx.PARTY_SITE_ID
4605: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
4606: yy
4607: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4608: else
4609: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

4610: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4611: xx
4612: where (nvl(STATUS, 'A') in ('A','I'))
4613: and xx.PARTY_SITE_ID
4614: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
4615: yy
4616: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4617: end if;
4618: --OKL_INS_POLICIES_B;ISU_ID

Line 4618: --OKL_INS_POLICIES_B;ISU_ID

4614: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
4615: yy
4616: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4617: end if;
4618: --OKL_INS_POLICIES_B;ISU_ID
4619: appid:=540;
4620: if(regid_proc = true) then
4621: 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
4622:

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

4619: appid:=540;
4620: if(regid_proc = true) then
4621: 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
4622:
4623: temp.party_id in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_B xx
4624: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4625: else
4626: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4627: temp.party_id in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_B xx

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

4623: temp.party_id in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_B xx
4624: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4625: else
4626: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4627: temp.party_id in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_B xx
4628: where (IPY_TYPE = 'THIRD_PARTY_POLICY'));
4629: end if;
4630: --OKL_EXT_SELL_INVS_B;CUSTOMER_ID
4631: appid:=540;