APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on GL_SETS_OF_BOOKS

Line 2447: gl_sets_of_books sob

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

Line 2457: gl_sets_of_books sob

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

Line 2706: gl_sets_of_books gsb,

2702: asp.org_id,
2703: asp.set_of_books_id
2704: FROM
2705: fnd_currencies fc,
2706: gl_sets_of_books gsb,
2707: ar_system_parameters asp
2708: WHERE
2709: gsb.set_of_books_id = asp.set_of_books_id
2710: AND fc.currency_code = gsb.currency_code;

Line 2913: gl_sets_of_books sob

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

Line 2923: gl_sets_of_books sob

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