APPS.ARP_PROCESS_ADJUSTMENT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 108: FROM ra_cust_trx_line_gl_dist d,

104: BEGIN
105: /* This invoice either has rules or created with contingency */
106: SELECT SUM(NVL(d.amount,0)) amount
107: INTO l_inv_amount
108: FROM ra_cust_trx_line_gl_dist d,
109: ar_payment_schedules p
110: WHERE p.payment_schedule_id = p_payment_schedule_id
111: AND d.customer_trx_id = p.customer_trx_id
112: AND d.account_class = 'UNEARN'

Line 121: FROM ra_cust_trx_line_gl_dist d,

117: /* There can any CM applied on this invoice that offsets the Unearn
118: balance on the invoice */
119: SELECT SUM(NVL(d.amount,0)) amount
120: INTO l_cm_amount
121: FROM ra_cust_trx_line_gl_dist d,
122: ra_customer_trx t,
123: ar_payment_schedules p
124: WHERE p.payment_schedule_id = p_payment_schedule_id
125: AND p.customer_trx_id = t.previous_customer_trx_id

Line 507: FROM ra_cust_trx_line_gl_dist ctlgd,

503: ctl.line_type) a,
504: (SELECT SUM(ctlgd.AMOUNT) sum_orig,
505: SUM(ctlgd.ACCTD_AMOUNT) sum_acctd_orig,
506: ctlgd.customer_trx_line_id
507: FROM ra_cust_trx_line_gl_dist ctlgd,
508: ra_customer_trx_lines ctll
509: WHERE ctlgd.customer_trx_id = p_customer_trx_id
510: AND ctlgd.customer_trx_line_id = ctll.customer_trx_line_id
511: AND (ctll.customer_trx_line_id = p_customer_trx_line_id