DBA Data[Home] [Help]

APPS.AR_RAAPI_UTIL dependencies on AR_PERIODS

Line 2599: FROM ar_periods p,

2595: in a calendar. */
2596:
2597: CURSOR c_start_period IS
2598: SELECT p.start_date, p.new_period_num
2599: FROM ar_periods p,
2600: gl_sets_of_books sob,
2601: ar_period_types tp
2602: WHERE sob.period_set_name = p.period_set_name
2603: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id

Line 2610: FROM ar_periods p,

2606: AND p_start_date BETWEEN p.start_date AND p.end_date;
2607:
2608: CURSOR c_current_period (p_new_period_num NUMBER) IS
2609: SELECT p.start_date, p.end_date
2610: FROM ar_periods p,
2611: gl_sets_of_books sob,
2612: ar_period_types tp
2613: WHERE sob.period_set_name = p.period_set_name
2614: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id