APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on AR_REVENUE_ASSIGNMENTS

Line 2523: FROM ar_revenue_assignments ar,

2519: l_acctd_round_flag boolean := FALSE;
2520:
2521: CURSOR c_assignment_count IS
2522: SELECT SUM(ar.amount), count(*)
2523: FROM ar_revenue_assignments ar,
2524: gl_sets_of_books sob
2525: WHERE customer_trx_line_id = p_customer_trx_line_id
2526: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2527: AND ar.period_set_name = sob.period_set_name

Line 2533: FROM ar_revenue_assignments ar,

2529:
2530: CURSOR c_revenue_assignment IS
2531: SELECT (ar.gl_date + l_deferred_days) gl_date,
2532: SUM(ar.amount) amount
2533: FROM ar_revenue_assignments ar,
2534: gl_sets_of_books sob
2535: WHERE ar.customer_trx_line_id = p_customer_trx_line_id
2536: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2537: AND ar.period_set_name = sob.period_set_name

Line 2764: will be based on ar_revenue_assignments returns */

2760:
2761: /* 6862351 - added p_gl_date. This will be used to override
2762: the gl_date of the distributions if the rule has
2763: only one period. For multiperiod schedules, the dates
2764: will be based on ar_revenue_assignments returns */
2765: PROCEDURE dists_by_model
2766: (p_customer_trx_id IN NUMBER
2767: ,p_customer_trx_line_id IN NUMBER
2768: ,p_revenue_amount IN NUMBER

Line 2847: ar_revenue_assignments ra

2843: ra_customer_trx h,
2844: fnd_currencies fc,
2845: ra_cust_trx_line_gl_dist dist,
2846: ra_cust_trx_line_salesreps srep,
2847: ar_revenue_assignments ra
2848: WHERE
2849: l.customer_trx_line_id = p_customer_trx_line_id
2850: AND fc.currency_code = h.invoice_currency_code
2851: AND l.customer_trx_id = h.customer_trx_id

Line 3097: FROM ar_revenue_assignments ar,

3093: invalid_ccid EXCEPTION;
3094:
3095: CURSOR c_assignment_count IS
3096: SELECT SUM(ar.amount), count(*)
3097: FROM ar_revenue_assignments ar,
3098: gl_sets_of_books sob
3099: WHERE customer_trx_line_id = p_customer_trx_line_id
3100: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
3101: AND ar.period_set_name = sob.period_set_name

Line 3107: FROM ar_revenue_assignments ar,

3103:
3104: CURSOR c_revenue_assignment IS
3105: SELECT ar.gl_date
3106: , SUM(ar.amount) amount
3107: FROM ar_revenue_assignments ar,
3108: gl_sets_of_books sob
3109: WHERE ar.customer_trx_line_id = p_customer_trx_line_id
3110: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
3111: AND ar.period_set_name = sob.period_set_name