DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2395: from ra_customer_trx_lines_all a

2391: l_lsm_id OKL_TXD_AR_LN_DTLS_B.lsm_id%type;
2392:
2393: Cursor get_invoice_line_id (p_rev_txn_id OKL_TXD_AR_LN_DTLS_B.id%type) is
2394: select a.customer_trx_line_id
2395: from ra_customer_trx_lines_all a
2396: where a.INTERFACE_LINE_ATTRIBUTE14 = to_char(p_rev_txn_id); -- AKP
2397:
2398: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;
2399:

Line 2398: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;

2394: select a.customer_trx_line_id
2395: from ra_customer_trx_lines_all a
2396: where a.INTERFACE_LINE_ATTRIBUTE14 = to_char(p_rev_txn_id); -- AKP
2397:
2398: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;
2399:
2400: --akrangan addeed ebtax billing impacts coding start
2401: CURSOR tax_sources_csr(p_tai_id IN NUMBER
2402: ,p_tld_id IN number