APPS.OKL_REVERSAL_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 225: FROM okl_trx_contracts_all o,

221: -- the representation code. SLA Uptake
222: -- extended to get the representation based on tcn_id.. MG Uptake
223: CURSOR get_gl_short_name_csr(p_tcn_id NUMBER) IS
224: SELECT rep.representation_code
225: FROM okl_trx_contracts_all o,
226: okl_representations_v rep
227: WHERE o.set_of_books_id = rep.ledger_id
228: AND o.id = p_tcn_id;
229:

Line 244: FROM okl_trx_types_tl t, okl_trx_contracts_all tcn

240:
241: -- Cursor to get transaction type name .. SLA Uptake
242: CURSOR get_try_name_csr(p_tcn_id IN NUMBER) IS
243: SELECT t.name
244: FROM okl_trx_types_tl t, okl_trx_contracts_all tcn
245: WHERE tcn.try_id = t.id
246: AND tcn.id = p_tcn_id
247: AND LANGUAGE = 'US';
248: