APPS.OKL_REVERSAL_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 218: FROM okl_trx_contracts_all o,

214: -- the representation code. SLA Uptake
215: -- extended to get the representation based on tcn_id.. MG Uptake
216: CURSOR get_gl_short_name_csr(p_tcn_id NUMBER) IS
217: SELECT rep.representation_code
218: FROM okl_trx_contracts_all o,
219: okl_representations_v rep
220: WHERE o.set_of_books_id = rep.ledger_id
221: AND o.id = p_tcn_id;
222:

Line 237: FROM okl_trx_types_tl t, okl_trx_contracts_all tcn

233:
234: -- Cursor to get transaction type name .. SLA Uptake
235: CURSOR get_try_name_csr(p_tcn_id IN NUMBER) IS
236: SELECT t.name
237: FROM okl_trx_types_tl t, okl_trx_contracts_all tcn
238: WHERE tcn.try_id = t.id
239: AND tcn.id = p_tcn_id
240: AND LANGUAGE = 'US';
241: