2757: CURSOR c_start_period IS
2758: SELECT p.start_date, p.new_period_num
2759: FROM ar_periods p,
2760: gl_sets_of_books sob,
2761: ar_period_types tp
2762: WHERE sob.period_set_name = p.period_set_name
2763: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2764: AND sob.accounted_period_type = p.period_type
2765: AND sob.accounted_period_type = tp.period_type
2768: CURSOR c_current_period (p_new_period_num NUMBER) IS
2769: SELECT p.start_date, p.end_date
2770: FROM ar_periods p,
2771: gl_sets_of_books sob,
2772: ar_period_types tp
2773: WHERE sob.period_set_name = p.period_set_name
2774: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2775: AND sob.accounted_period_type = p.period_type
2776: AND sob.accounted_period_type = tp.period_type