APPS.HZ_PURGE_GEN dependencies on OKL_EXT_SELL_INVS_B

Line 4630: --OKL_EXT_SELL_INVS_B;CUSTOMER_ID

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;
4632: if(regid_proc = true) then
4633: 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
4634:

Line 4635: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from OKL_EXT_SELL_INVS_B xx

4631: appid:=540;
4632: if(regid_proc = true) then
4633: 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
4634:
4635: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from OKL_EXT_SELL_INVS_B xx
4636: );
4637: else
4638: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4639: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from OKL_EXT_SELL_INVS_B xx

Line 4639: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from OKL_EXT_SELL_INVS_B xx

4635: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from OKL_EXT_SELL_INVS_B xx
4636: );
4637: else
4638: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4639: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from OKL_EXT_SELL_INVS_B xx
4640: );
4641: end if;
4642: --OKL_OPEN_INT;PARTY_ID
4643: appid:=540;