DBA Data[Home] [Help]

APPS.FUN_NET_ARAP_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 2320: l_total_amount ra_cust_trx_line_gl_dist.amount%TYPE;

2316: FUNCTION calculate_ar_trx_amt(
2317: p_customer_trx_id NUMBER)
2318: RETURN NUMBER
2319: IS
2320: l_total_amount ra_cust_trx_line_gl_dist.amount%TYPE;
2321: BEGIN
2322: SELECT sum(amount)
2323: INTO l_total_amount
2324: from ra_cust_trx_line_gl_dist dist,

Line 2324: from ra_cust_trx_line_gl_dist dist,

2320: l_total_amount ra_cust_trx_line_gl_dist.amount%TYPE;
2321: BEGIN
2322: SELECT sum(amount)
2323: INTO l_total_amount
2324: from ra_cust_trx_line_gl_dist dist,
2325: ra_customer_trx_lines_all lines
2326: Where lines.customer_trx_id = p_customer_trx_id
2327: And lines.customer_trx_line_id = dist.customer_trx_line_id
2328: And dist.account_class <> 'REC';