APPS.OKL_REVERSE_CONTRACT_PVT dependencies on OKL_TXL_AP_INV_LNS_ALL_B

Line 126: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b instead

122: AND A.ID = B.TAS_ID
123: AND A.TRY_ID = TTB.ID
124: AND TTB.TRX_TYPE_CLASS NOT IN (G_INTERNAL_ASSET_CREATION);
125:
126: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b instead
127: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project
128: CURSOR ap_inv_cur IS
129: SELECT '1'
130: FROM OKL_TRX_AP_INVOICES_B TAI, OKL_TRX_TYPES_B TTB

Line 131: ,OKL_TXL_AP_INV_LNS_ALL_B TPL

127: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project
128: CURSOR ap_inv_cur IS
129: SELECT '1'
130: FROM OKL_TRX_AP_INVOICES_B TAI, OKL_TRX_TYPES_B TTB
131: ,OKL_TXL_AP_INV_LNS_ALL_B TPL
132: WHERE TAI.ID = TPL.TAP_ID
133: AND TPL.KHR_ID = p_contract_id
134: AND TAI.TRY_ID = TTB.ID
135: AND TTB.TRX_TYPE_CLASS NOT IN (G_FUNDING)

Line 272: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b instead

268: SELECT ID
269: FROM OKL_TXL_ASSETS_B TA
270: WHERE TA.TAS_ID = p_tas_id;
271:
272: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b instead
273: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project
274: CURSOR ap_inv_trx_cur IS
275: SELECT a.ID, a.try_id
276: FROM OKL_TRX_AP_INVOICES_B a

Line 277: ,okl_txl_ap_inv_lns_all_b b

273: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project
274: CURSOR ap_inv_trx_cur IS
275: SELECT a.ID, a.try_id
276: FROM OKL_TRX_AP_INVOICES_B a
277: ,okl_txl_ap_inv_lns_all_b b
278: WHERE a.id = b.tap_id
279: AND b.khr_id = p_contract_id;
280:
281: CURSOR ap_inv_trx_lines_cur (p_tap_id NUMBER) IS

Line 710: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b instead

706: WHERE KHR_ID = p_contract_id
707: --rkuttiya added for 12.1.1 Multi GAAP
708: AND REPRESENTATION_TYPE = 'PRIMARY';
709:
710: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b instead
711: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project
712: CURSOR ap_inv_trx_cur IS
713: SELECT '1'
714: FROM OKL_TRX_AP_INVOICES_B a

Line 715: , okl_txl_ap_inv_lns_all_b b

711: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project
712: CURSOR ap_inv_trx_cur IS
713: SELECT '1'
714: FROM OKL_TRX_AP_INVOICES_B a
715: , okl_txl_ap_inv_lns_all_b b
716: WHERE a.id = b.tap_id
717: AND b.KHR_ID = p_contract_id;
718:
719: CURSOR asset_trx_cur IS