APPS.OKL_BILLING_UTIL_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 44: FROM ra_customer_trx_all ractrx

40:
41: -- Cursor to obtain the last invoice date for a contract
42: CURSOR c_last_invoice_date(p_contract_id IN NUMBER) IS
43: SELECT max(ractrx.trx_date)
44: FROM ra_customer_trx_all ractrx
45: WHERE EXISTS (
46: SELECT 'x'
47: FROM ra_customer_trx_lines_all ractrl
48: WHERE ractrl.customer_trx_id = ractrx.customer_trx_id

Line 440: RA_CUSTOMER_TRX_ALL RACTRX

436: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
437: CURSOR invoice_amount_orig_csr(p_header_id NUMBER) IS
438: SELECT SUM(NVL(APS.AMOUNT_DUE_ORIGINAL,0)) AMOUNT_DUE_ORIGINAL
439: FROM AR_PAYMENT_SCHEDULES_ALL APS,
440: RA_CUSTOMER_TRX_ALL RACTRX
441: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
442: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
443: l_invoice_amount_orig NUMBER;
444: BEGIN

Line 498: RA_CUSTOMER_TRX_ALL RACTRX

494: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
495: CURSOR invoice_amount_remaining_csr(p_header_id NUMBER) IS
496: SELECT SUM(NVL(APS.AMOUNT_DUE_REMAINING,0)) AMOUNT_DUE_REMAINING
497: FROM AR_PAYMENT_SCHEDULES_ALL APS,
498: RA_CUSTOMER_TRX_ALL RACTRX
499: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
500: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
501: l_invoice_amount_remaining NUMBER;
502: BEGIN

Line 852: RA_CUSTOMER_TRX_ALL HDR

848:
849: CURSOR cust_trx_csr(p_cust_trx_number VARCHAR2, p_contract_number VARCHAR2) IS
850: SELECT LNS.CUSTOMER_TRX_ID
851: FROM RA_CUSTOMER_TRX_LINES_ALL LNS,
852: RA_CUSTOMER_TRX_ALL HDR
853: WHERE LNS.INTERFACE_LINE_ATTRIBUTE6 = p_contract_number
854: AND HDR.TRX_NUMBER = p_cust_trx_number
855: AND HDR.CUSTOMER_TRX_ID = LNS.CUSTOMER_TRX_ID;
856:

Line 1319: RA_CUSTOMER_TRX_ALL RACTRX

1315: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
1316: CURSOR invoice_amount_remaining_csr(p_header_id NUMBER) IS
1317: SELECT SUM(NVL(APS.AMOUNT_DUE_REMAINING,0)) AMOUNT_DUE_REMAINING
1318: FROM AR_PAYMENT_SCHEDULES_ALL APS,
1319: RA_CUSTOMER_TRX_ALL RACTRX
1320: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
1321: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
1322: l_invoice_amount_remaining NUMBER;
1323: BEGIN

Line 1417: RA_CUSTOMER_TRX_ALL RACTRX

1413: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
1414: CURSOR invoice_amount_adj_csr(p_header_id NUMBER) IS
1415: SELECT SUM(NVL(APS.AMOUNT_ADJUSTED,0)) AMOUNT_ADJUSTED
1416: FROM AR_PAYMENT_SCHEDULES_ALL APS,
1417: RA_CUSTOMER_TRX_ALL RACTRX
1418: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
1419: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
1420: l_invoice_amount_adj NUMBER;
1421: BEGIN