Line 297: AND set_of_books_id = igs_fi_gen_007.get_sob_id;
293: CURSOR cur_closing_status IS
294: SELECT closing_status
295: FROM igs_fi_gl_periods_v
296: WHERE TRUNC(p_d_date) BETWEEN TRUNC(start_date) AND TRUNC(end_date) 297: AND set_of_books_id = igs_fi_gen_007.get_sob_id; 298:
299: BEGIN
300: p_v_message_name := NULL;
301: p_v_closing_status := NULL;