APPS.IGS_FI_GL_INTERFACE dependencies on GL_PERIOD_STATUSES

Line 1005: l_v_period_name gl_period_statuses.period_name%TYPE;

1001: run journal import is set to Y and the start date is in a period that
1002: is closed.
1003: ********************************************************************************************** */
1004: l_b_val_parm BOOLEAN;
1005: l_v_period_name gl_period_statuses.period_name%TYPE;
1006: l_d_end_date DATE;
1007: l_v_sob_name gl_sets_of_books.name%TYPE;
1008: l_log_line VARCHAR2(2000);
1009: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 1026: -- Cursor for selecting the records from gl period statuses table

1022: SELECT name
1023: FROM gl_sets_of_books
1024: WHERE set_of_books_id = cp_sob_id;
1025:
1026: -- Cursor for selecting the records from gl period statuses table
1027: CURSOR cur_glp(cp_app_id NUMBER,
1028: cp_gl_date_start DATE,
1029: cp_sob_id igs_fi_control.set_of_books_id%TYPE) IS
1030: SELECT period_name, end_date

Line 1031: FROM gl_period_statuses a

1027: CURSOR cur_glp(cp_app_id NUMBER,
1028: cp_gl_date_start DATE,
1029: cp_sob_id igs_fi_control.set_of_books_id%TYPE) IS
1030: SELECT period_name, end_date
1031: FROM gl_period_statuses a
1032: WHERE TRUNC(start_date) <= TRUNC(cp_gl_date_start)
1033: AND TRUNC(end_date) >= TRUNC(cp_gl_date_start)
1034: AND CLOSING_STATUS = 'O'
1035: AND APPLICATION_ID = cp_app_id