APPS.OKL_REVERSAL_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 215: from okl_txl_cntrct_lns

211: dist_rec dist_csr%ROWTYPE;
212:
213: cursor get_txl_amt is
214: select nvl(amount, 0)
215: from okl_txl_cntrct_lns
216: where id = p_source_id;
217:
218: l_txl_amt number;
219:

Line 238: FROM okl_txl_cntrct_lns_all

234:
235: --Cursor to get the transaction header id .. SLA Uptake
236: CURSOR get_tcn_id_csr IS
237: SELECT tcn_id
238: FROM okl_txl_cntrct_lns_all
239: WHERE id = p_source_id;
240:
241: -- Cursor to get transaction type name .. SLA Uptake
242: CURSOR get_try_name_csr(p_tcn_id IN NUMBER) IS

Line 375: IF p_source_table = 'OKL_TXL_CNTRCT_LNS' THEN

371: OPEN get_acct_derivation_csr;
372: FETCH get_acct_derivation_csr INTO l_account_derivation_option;
373: CLOSE get_acct_derivation_csr;
374:
375: IF p_source_table = 'OKL_TXL_CNTRCT_LNS' THEN
376: OPEN get_tcn_id_csr;
377: FETCH get_tcn_id_csr INTO l_tcn_id;
378: CLOSE get_tcn_id_csr;
379: