APPS.GMF_SUBLEDGER_PKG dependencies on GL_PERIOD_STATUSES

Line 759: gl_period_statuses sts,

755: SELECT glp.period_name, glp.period_year, glp.period_num,
756: glp.start_date, glp.end_date, sts.closing_status
757: FROM
758: gl_periods glp,
759: gl_period_statuses sts,
760: gl_sets_of_books gsob
761: WHERE
762: glp.period_set_name = gsob.period_set_name -- use the sob period-name
763: AND glp.period_type = gsob.accounted_period_type -- and sob period-type

Line 795: l_gl_period_status gl_period_statuses.closing_status%TYPE;

791: l_gl_per_real_start_date DATE;
792: l_gl_per_end_date DATE;
793: l_gl_per_real_end_date DATE;
794:
795: l_gl_period_status gl_period_statuses.closing_status%TYPE;
796: l_gl_period_status_2 gl_period_statuses.closing_status%TYPE;
797:
798: l_closed_per_ind NUMBER(2) := 0;
799: l_crev_gl_trans_date DATE;

Line 796: l_gl_period_status_2 gl_period_statuses.closing_status%TYPE;

792: l_gl_per_end_date DATE;
793: l_gl_per_real_end_date DATE;
794:
795: l_gl_period_status gl_period_statuses.closing_status%TYPE;
796: l_gl_period_status_2 gl_period_statuses.closing_status%TYPE;
797:
798: l_closed_per_ind NUMBER(2) := 0;
799: l_crev_gl_trans_date DATE;
800: l_crev_gl_date DATE;