APPS.OKL_REVERSE_CONTRACT_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 127: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project

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
131: ,OKL_TXL_AP_INV_LNS_ALL_B TPL

Line 130: FROM OKL_TRX_AP_INVOICES_B TAI, OKL_TRX_TYPES_B TTB

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
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

Line 273: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project

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
277: ,okl_txl_ap_inv_lns_all_b b

Line 276: FROM OKL_TRX_AP_INVOICES_B a

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
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:

Line 711: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project

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
715: , okl_txl_ap_inv_lns_all_b b

Line 714: FROM OKL_TRX_AP_INVOICES_B a

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
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: