APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 2973: FROM ra_cust_trx_line_gl_dist

2969: -- for the invoice.
2970:
2971: CURSOR c IS
2972: SELECT 1
2973: FROM ra_cust_trx_line_gl_dist
2974: WHERE customer_trx_id = p_customer_trx_id
2975: AND account_set_flag = 'N'
2976: AND rownum = 1;
2977:

Line 6392: ra_cust_trx_line_gl_dist gld

6388: SUM(NVL(gld.amount,0)), SUM(NVL(gld.acctd_amount,0)),
6389: SUM(decode(ctrl.customer_trx_id, NULL, 0, 1))
6390: FROM ar_deferred_lines adl,
6391: ra_customer_trx_lines ctrl,
6392: ra_cust_trx_line_gl_dist gld
6393: WHERE adl.customer_trx_id = p_trx_id
6394: AND adl.customer_trx_id = ctrl.previous_customer_trx_id (+)
6395: AND adl.customer_trx_line_id = ctrl.previous_customer_trx_line_id (+)
6396: AND ctrl.customer_trx_line_id = gld.customer_trx_line_id (+)

Line 6414: FROM ra_cust_trx_line_gl_dist gld,

6410:
6411: /* 9320279 - added to fetch total CM amounts for proration */
6412: CURSOR cm_amounts (p_trx_id NUMBER) IS
6413: SELECT sum(nvl(amount,0)), sum(nvl(acctd_amount,0))
6414: FROM ra_cust_trx_line_gl_dist gld,
6415: ra_customer_trx ctrx
6416: WHERE ctrx.previous_customer_trx_id = p_trx_id
6417: AND ctrx.customer_trx_id = gld.customer_trx_id
6418: AND account_class in ('REV','UNEARN');