APPS.IGS_FI_GEN_GL dependencies on IGS_FI_GL_PERIODS_V

Line 292: --access the view IGS_FI_GL_PERIODS_V to get the CLOSING_STATUS of the period in which the passed P_D_DATE belongs to.

288:
289:
290:
291: --Cursor to Derive the Set Of books defined in the system options form- Use the Set of Books ID derived (SET_OF_BOOKS_ID) to
292: --access the view IGS_FI_GL_PERIODS_V to get the CLOSING_STATUS of the period in which the passed P_D_DATE belongs to.
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)

Line 295: FROM igs_fi_gl_periods_v

291: --Cursor to Derive the Set Of books defined in the system options form- Use the Set of Books ID derived (SET_OF_BOOKS_ID) to
292: --access the view IGS_FI_GL_PERIODS_V to get the CLOSING_STATUS of the period in which the passed P_D_DATE belongs to.
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

Line 319: --access the view IGS_FI_GL_PERIODS_V to get the CLOSING_STATUS of the period in which the passed P_D_DATE belongs to.

315: RETURN;
316: END IF;
317:
318: --Derive the Set Of books defined in the system options form- Use the Set of Books ID derived (SET_OF_BOOKS_ID) to
319: --access the view IGS_FI_GL_PERIODS_V to get the CLOSING_STATUS of the period in which the passed P_D_DATE belongs to.
320: OPEN cur_closing_status;
321: FETCH cur_closing_status INTO p_v_closing_status;
322: IF cur_closing_status%NOTFOUND THEN
323: CLOSE cur_closing_status;