APPS.ARP_TRX_LINE_UTIL dependencies on AR_REVENUE_ASSIGNMENTS

Line 62: FROM ar_revenue_assignments

58: SELECT MAX(gl_date),
59: count(*)
60: INTO l_last_gl_date,
61: l_count
62: FROM ar_revenue_assignments
63: WHERE customer_trx_line_id = p_customer_trx_line_id
64: AND account_class = 'REV'
65: AND period_set_name = l_period_set_name
66: AND rownum <= DECODE(p_last_period_to_cr -

Line 83: FROM ar_revenue_assignments

79: SELECT ( (l_last_gl_date - max(gl_date) ) *
80: (p_last_period_to_cr - trunc(p_last_period_to_cr, 0) )
81: ) + max(gl_date)
82: INTO l_last_gl_date
83: FROM ar_revenue_assignments
84: WHERE customer_trx_line_id = p_customer_trx_line_id
85: AND account_class = 'REV'
86: AND period_set_name = l_period_set_name
87: AND rownum <= l_count - 1;

Line 140: ar_revenue_assignments ra

136:
137: CURSOR gl_dates IS
138: SELECT gl_date
139: FROM ra_customer_trx_lines l,
140: ar_revenue_assignments ra
141: WHERE l.customer_trx_line_id = p_customer_trx_line_id
142: AND l.customer_trx_line_id = ra.customer_trx_line_id
143: AND ra.account_class = 'REV'
144: ORDER BY gl_date;

Line 162: ar_revenue_assignments ra

158: MAX(gl_date)
159: INTO l_min_gl_date,
160: l_max_gl_date
161: FROM ra_customer_trx_lines l,
162: ar_revenue_assignments ra
163: WHERE l.customer_trx_line_id = p_customer_trx_line_id
164: AND l.customer_trx_line_id = ra.customer_trx_line_id
165: AND ra.account_class = 'REV';
166: