DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1429: from ra_customer_trx_lines_all a

1425: l_lsm_id OKL_TXD_AR_LN_DTLS_B.lsm_id%type;
1426:
1427: Cursor get_invoice_line_id (p_rev_txn_id OKL_TXD_AR_LN_DTLS_B.id%type) is
1428: select a.customer_trx_line_id
1429: from ra_customer_trx_lines_all a
1430: where a.INTERFACE_LINE_ATTRIBUTE14 = to_char(p_rev_txn_id); -- AKP
1431:
1432: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;
1433:

Line 1432: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;

1428: select a.customer_trx_line_id
1429: from ra_customer_trx_lines_all a
1430: where a.INTERFACE_LINE_ATTRIBUTE14 = to_char(p_rev_txn_id); -- AKP
1431:
1432: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;
1433:
1434: --akrangan addeed ebtax billing impacts coding start
1435: CURSOR tax_sources_csr(p_tai_id IN NUMBER
1436: ,p_tld_id IN number