APPS.ARP_PROCESS_RETURNS dependencies on RA_CUSTOMER_TRX_LINES

Line 1279: l_total_cm_amount RA_CUSTOMER_TRX_LINES.EXTENDED_AMOUNT%TYPE;

1275: --
1276: FUNCTION get_total_cm_amount (p_inv_customer_trx_id IN NUMBER,
1277: p_request_id IN NUMBER) RETURN NUMBER AS
1278:
1279: l_total_cm_amount RA_CUSTOMER_TRX_LINES.EXTENDED_AMOUNT%TYPE;
1280:
1281: BEGIN
1282: --
1283: IF PG_DEBUG in ('Y', 'C') THEN

Line 1291: FROM RA_CUSTOMER_TRX_LINES

1287: END IF;
1288: --
1289: SELECT NVL(SUM(extended_amount) , 0)
1290: INTO l_total_cm_amount
1291: FROM RA_CUSTOMER_TRX_LINES
1292: WHERE previous_customer_trx_id = p_inv_customer_trx_id
1293: AND request_id = p_request_id;
1294: --
1295: IF PG_DEBUG in ('Y', 'C') THEN

Line 1753: ra_customer_trx_lines lines

1749: ---
1750: select count(*)
1751: into l_count
1752: from ar_activity_details aad,
1753: ra_customer_trx_lines lines
1754: where
1755: lines.customer_trx_id = p_customer_trx_id
1756: and nvl(aad.CURRENT_ACTIVITY_FLAG,'Y') = 'Y'
1757: and aad.customer_trx_line_id = lines.customer_trx_line_id;