DBA Data[Home] [Help]

APPS.FUN_NET_ARAP_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 1599: l_total_amount ra_cust_trx_line_gl_dist.amount%TYPE;

1595: FUNCTION calculate_ar_trx_amt(
1596: p_customer_trx_id NUMBER)
1597: RETURN NUMBER
1598: IS
1599: l_total_amount ra_cust_trx_line_gl_dist.amount%TYPE;
1600: BEGIN
1601:
1602: SELECT sum(amount)
1603: INTO l_total_amount

Line 1604: from ra_cust_trx_line_gl_dist dist,

1600: BEGIN
1601:
1602: SELECT sum(amount)
1603: INTO l_total_amount
1604: from ra_cust_trx_line_gl_dist dist,
1605: ra_customer_trx_lines_all lines
1606: Where lines.customer_trx_id = p_customer_trx_id
1607: And lines.customer_trx_line_id = dist.customer_trx_line_id
1608: And dist.account_class <> 'REC';