APPS.HZ_PURGE_GEN dependencies on OKL_EXT_SELL_INVS_ALL_B

Line 4838: --OKL_EXT_SELL_INVS_ALL_B;CUSTOMER_ID

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;
4840: if(regid_proc = true) then
4841: 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
4842:

Line 4847: in (select /*+ parallel(yy)*/ yy.CUSTOMER_ID from OKL_EXT_SELL_INVS_ALL_B

4843: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_CUST_ACCOUNTS
4844: xx
4845: where (nvl(STATUS, 'A') in ('A','I'))
4846: and xx.CUST_ACCOUNT_ID
4847: in (select /*+ parallel(yy)*/ yy.CUSTOMER_ID from OKL_EXT_SELL_INVS_ALL_B
4848: yy
4849: ))
4850: or temp.party_id in (select /*+ parallel (xx)*/ xx.SELLING_PARTY_ID from HZ_CUST_ACCOUNTS
4851: xx

Line 4854: in (select /*+ parallel(yy)*/ yy.CUSTOMER_ID from OKL_EXT_SELL_INVS_ALL_B

4850: or temp.party_id in (select /*+ parallel (xx)*/ xx.SELLING_PARTY_ID from HZ_CUST_ACCOUNTS
4851: xx
4852: where (nvl(STATUS, 'A') in ('A','I'))
4853: and xx.CUST_ACCOUNT_ID
4854: in (select /*+ parallel(yy)*/ yy.CUSTOMER_ID from OKL_EXT_SELL_INVS_ALL_B
4855: yy
4856: ));
4857: else
4858: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4863: in (select /*+ parallel(yy)*/ yy.CUSTOMER_ID from OKL_EXT_SELL_INVS_ALL_B

4859: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_CUST_ACCOUNTS
4860: xx
4861: where (nvl(STATUS, 'A') in ('A','I'))
4862: and xx.CUST_ACCOUNT_ID
4863: in (select /*+ parallel(yy)*/ yy.CUSTOMER_ID from OKL_EXT_SELL_INVS_ALL_B
4864: yy
4865: ))
4866: or temp.party_id in (select /*+ parallel (xx)*/ xx.SELLING_PARTY_ID from HZ_CUST_ACCOUNTS
4867: xx

Line 4870: in (select /*+ parallel(yy)*/ yy.CUSTOMER_ID from OKL_EXT_SELL_INVS_ALL_B

4866: or temp.party_id in (select /*+ parallel (xx)*/ xx.SELLING_PARTY_ID from HZ_CUST_ACCOUNTS
4867: xx
4868: where (nvl(STATUS, 'A') in ('A','I'))
4869: and xx.CUST_ACCOUNT_ID
4870: in (select /*+ parallel(yy)*/ yy.CUSTOMER_ID from OKL_EXT_SELL_INVS_ALL_B
4871: yy
4872: ));
4873: end if;
4874: --OKL_OPEN_INT_ALL;PARTY_ID