APPS.ARP_PROCESS_RETURNS dependencies on RA_CUSTOMER_TRX_LINES

Line 1307: l_total_cm_amount RA_CUSTOMER_TRX_LINES.EXTENDED_AMOUNT%TYPE;

1303: --
1304: FUNCTION get_total_cm_amount (p_inv_customer_trx_id IN NUMBER,
1305: p_request_id IN NUMBER) RETURN NUMBER AS
1306:
1307: l_total_cm_amount RA_CUSTOMER_TRX_LINES.EXTENDED_AMOUNT%TYPE;
1308:
1309: BEGIN
1310: --
1311: IF PG_DEBUG in ('Y', 'C') THEN

Line 1319: FROM RA_CUSTOMER_TRX_LINES

1315: END IF;
1316: --
1317: SELECT NVL(SUM(extended_amount) , 0)
1318: INTO l_total_cm_amount
1319: FROM RA_CUSTOMER_TRX_LINES
1320: WHERE previous_customer_trx_id = p_inv_customer_trx_id
1321: AND request_id = p_request_id;
1322: --
1323: IF PG_DEBUG in ('Y', 'C') THEN

Line 1781: ra_customer_trx_lines lines

1777: ---
1778: select count(*)
1779: into l_count
1780: from ar_activity_details aad,
1781: ra_customer_trx_lines lines
1782: where
1783: lines.customer_trx_id = p_customer_trx_id
1784: and nvl(aad.CURRENT_ACTIVITY_FLAG,'Y') = 'Y'
1785: and aad.customer_trx_line_id = lines.customer_trx_line_id;