eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_REVENUE_ASSIGNMENTS dependencies on AR_PERIODS

Line 283: ar_periods arp1, -- first period

279: SET pprr_amount =
280: (SELECT Sum(ilgd.amount)
281: FROM ra_customer_trx_lines il,
282: ra_cust_trx_line_gl_dist ilgd,
283: ar_periods arp1, -- first period
284: ar_periods arp2 -- current period
285: WHERE ragt.customer_trx_line_id = il.customer_trx_line_id
286: AND il.rule_start_date BETWEEN arp1.start_date AND arp1.end_date
287: AND arp2.new_period_num >= arp1.new_period_num

Line 284: ar_periods arp2 -- current period

280: (SELECT Sum(ilgd.amount)
281: FROM ra_customer_trx_lines il,
282: ra_cust_trx_line_gl_dist ilgd,
283: ar_periods arp1, -- first period
284: ar_periods arp2 -- current period
285: WHERE ragt.customer_trx_line_id = il.customer_trx_line_id
286: AND il.rule_start_date BETWEEN arp1.start_date AND arp1.end_date
287: AND arp2.new_period_num >= arp1.new_period_num
288: AND arp1.period_type = ragt.period_type