DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 2160: l_ar_inv_num ra_customer_trx_all.trx_number%TYPE;

2156: l_msg_count NUMBER;
2157: l_msg_data VARCHAR2(2000);
2158: l_cnt NUMBER;
2159: l_err_cnt NUMBER;
2160: l_ar_inv_num ra_customer_trx_all.trx_number%TYPE;
2161:
2162: -- ------------------------------------------
2163: -- For Screen Display of AR Invoice Number
2164: -- ------------------------------------------

Line 2167: FROM ra_customer_trx_all

2163: -- For Screen Display of AR Invoice Number
2164: -- ------------------------------------------
2165: CURSOR ar_invs_csr( p_cust_trx_id NUMBER ) IS
2166: SELECT trx_number
2167: FROM ra_customer_trx_all
2168: WHERE customer_trx_id = p_cust_trx_id;
2169:
2170: CURSOR ar_trx_errs_csr( p_hdr_id NUMBER ) IS
2171: SELECT *