APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on AR_REVENUE_ASSIGNMENTS

Line 2446: FROM ar_revenue_assignments ar,

2442: l_acctd_round_flag boolean := FALSE;
2443:
2444: CURSOR c_assignment_count IS
2445: SELECT SUM(ar.amount), count(*)
2446: FROM ar_revenue_assignments ar,
2447: gl_sets_of_books sob
2448: WHERE customer_trx_line_id = p_customer_trx_line_id
2449: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2450: AND ar.period_set_name = sob.period_set_name

Line 2456: FROM ar_revenue_assignments ar,

2452:
2453: CURSOR c_revenue_assignment IS
2454: SELECT (ar.gl_date + l_deferred_days) gl_date,
2455: SUM(ar.amount) amount
2456: FROM ar_revenue_assignments ar,
2457: gl_sets_of_books sob
2458: WHERE ar.customer_trx_line_id = p_customer_trx_line_id
2459: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2460: AND ar.period_set_name = sob.period_set_name

Line 2687: will be based on ar_revenue_assignments returns */

2683:
2684: /* 6862351 - added p_gl_date. This will be used to override
2685: the gl_date of the distributions if the rule has
2686: only one period. For multiperiod schedules, the dates
2687: will be based on ar_revenue_assignments returns */
2688: PROCEDURE dists_by_model
2689: (p_customer_trx_line_id IN NUMBER
2690: ,p_revenue_amount IN NUMBER
2691: ,p_adjustment_id IN NUMBER

Line 2831: ar_revenue_assignments ra

2827: ra_customer_trx_lines l,
2828: ra_customer_trx h,
2829: fnd_currencies fc,
2830: ra_cust_trx_line_gl_dist dist,
2831: ar_revenue_assignments ra
2832: WHERE
2833: l.customer_trx_line_id = p_customer_trx_line_id
2834: AND fc.currency_code = h.invoice_currency_code
2835: AND l.customer_trx_id = h.customer_trx_id

Line 2912: FROM ar_revenue_assignments ar,

2908: invalid_ccid EXCEPTION;
2909:
2910: CURSOR c_assignment_count IS
2911: SELECT SUM(ar.amount), count(*)
2912: FROM ar_revenue_assignments ar,
2913: gl_sets_of_books sob
2914: WHERE customer_trx_line_id = p_customer_trx_line_id
2915: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2916: AND ar.period_set_name = sob.period_set_name

Line 2922: FROM ar_revenue_assignments ar,

2918:
2919: CURSOR c_revenue_assignment IS
2920: SELECT ar.gl_date
2921: , SUM(ar.amount) amount
2922: FROM ar_revenue_assignments ar,
2923: gl_sets_of_books sob
2924: WHERE ar.customer_trx_line_id = p_customer_trx_line_id
2925: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2926: AND ar.period_set_name = sob.period_set_name