APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on GL_SETS_OF_BOOKS

Line 2524: gl_sets_of_books sob

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
2528: AND ar.account_class = 'REV';

Line 2534: gl_sets_of_books sob

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
2538: AND ar.account_class = 'REV'

Line 2788: gl_sets_of_books gsb,

2784: asp.org_id,
2785: asp.set_of_books_id
2786: FROM
2787: fnd_currencies fc,
2788: gl_sets_of_books gsb,
2789: ar_system_parameters asp
2790: WHERE
2791: gsb.set_of_books_id = asp.set_of_books_id
2792: AND fc.currency_code = gsb.currency_code;

Line 3098: gl_sets_of_books sob

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
3102: AND ar.account_class = 'REV';

Line 3108: gl_sets_of_books sob

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
3112: AND ar.account_class = 'REV'