APPS.HZ_PURGE_GEN dependencies on OKL_TRX_CONTRACTS_ALL

Line 4576: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID1_OLD

4572: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4573: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.OBJECT1_ID1 from OKC_K_PARTY_ROLES_B xx
4574: where (JTOT_OBJECT1_CODE = 'OKX_PARTY' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4575: end if;
4576: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID1_OLD
4577: appid:=540;
4578: if(regid_proc = true) then
4579: 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
4580:

Line 4581: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_OLD from OKL_TRX_CONTRACTS_ALL xx

4577: appid:=540;
4578: if(regid_proc = true) then
4579: 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
4580:
4581: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_OLD from OKL_TRX_CONTRACTS_ALL xx
4582: );
4583: else
4584: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4585: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_OLD from OKL_TRX_CONTRACTS_ALL xx

Line 4585: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_OLD from OKL_TRX_CONTRACTS_ALL xx

4581: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_OLD from OKL_TRX_CONTRACTS_ALL xx
4582: );
4583: else
4584: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4585: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_OLD from OKL_TRX_CONTRACTS_ALL xx
4586: );
4587: end if;
4588: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID2_OLD
4589: appid:=540;

Line 4588: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID2_OLD

4584: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4585: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_OLD from OKL_TRX_CONTRACTS_ALL xx
4586: );
4587: end if;
4588: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID2_OLD
4589: appid:=540;
4590: if(regid_proc = true) then
4591: 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
4592:

Line 4593: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_OLD from OKL_TRX_CONTRACTS_ALL xx

4589: appid:=540;
4590: if(regid_proc = true) then
4591: 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
4592:
4593: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_OLD from OKL_TRX_CONTRACTS_ALL xx
4594: );
4595: else
4596: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4597: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_OLD from OKL_TRX_CONTRACTS_ALL xx

Line 4597: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_OLD from OKL_TRX_CONTRACTS_ALL xx

4593: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_OLD from OKL_TRX_CONTRACTS_ALL xx
4594: );
4595: else
4596: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4597: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_OLD from OKL_TRX_CONTRACTS_ALL xx
4598: );
4599: end if;
4600: --OKL_LEASE_APPS_ALL_B;PROSPECT_ADDRESS_ID
4601: appid:=540;

Line 4792: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID2_NEW

4788: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4789: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_OBJECT_ID1 from OKL_TERMNT_INTF_PTY xx
4790: where (PARTY_OBJECT_CODE = 'OKX_PARTY'));
4791: end if;
4792: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID2_NEW
4793: appid:=540;
4794: if(regid_proc = true) then
4795: 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
4796:

Line 4797: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_NEW from OKL_TRX_CONTRACTS_ALL xx

4793: appid:=540;
4794: if(regid_proc = true) then
4795: 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
4796:
4797: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_NEW from OKL_TRX_CONTRACTS_ALL xx
4798: );
4799: else
4800: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4801: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_NEW from OKL_TRX_CONTRACTS_ALL xx

Line 4801: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_NEW from OKL_TRX_CONTRACTS_ALL xx

4797: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_NEW from OKL_TRX_CONTRACTS_ALL xx
4798: );
4799: else
4800: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4801: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_NEW from OKL_TRX_CONTRACTS_ALL xx
4802: );
4803: end if;
4804: --OKC_RULES_B;OBJECT1_ID1
4805: appid:=540;

Line 4826: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID1_NEW

4822: in (select /*+ parallel(yy)*/ yy.OBJECT1_ID1 from OKC_RULES_B
4823: yy
4824: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4825: end if;
4826: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID1_NEW
4827: appid:=540;
4828: if(regid_proc = true) then
4829: 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
4830:

Line 4831: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_NEW from OKL_TRX_CONTRACTS_ALL xx

4827: appid:=540;
4828: if(regid_proc = true) then
4829: 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
4830:
4831: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_NEW from OKL_TRX_CONTRACTS_ALL xx
4832: );
4833: else
4834: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4835: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_NEW from OKL_TRX_CONTRACTS_ALL xx

Line 4835: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_NEW from OKL_TRX_CONTRACTS_ALL xx

4831: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_NEW from OKL_TRX_CONTRACTS_ALL xx
4832: );
4833: else
4834: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4835: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID1_NEW from OKL_TRX_CONTRACTS_ALL xx
4836: );
4837: end if;
4838: --OKL_EXT_SELL_INVS_ALL_B;CUSTOMER_ID
4839: appid:=540;