APPS.GMF_SUBLEDGER_PKG dependencies on GL_PERIOD_STATUSES

Line 1200: gl_period_statuses sts,

1196: SELECT glp.period_name, glp.period_year, glp.period_num,
1197: glp.start_date, glp.end_date, sts.closing_status
1198: FROM
1199: gl_periods glp,
1200: gl_period_statuses sts,
1201: gl_sets_of_books gsob
1202: WHERE
1203: glp.period_set_name = gsob.period_set_name -- use the sob period-name
1204: AND glp.period_type = gsob.accounted_period_type -- and sob period-type

Line 1239: l_gl_period_status gl_period_statuses.closing_status%TYPE;

1235: l_gl_per_real_start_date DATE;
1236: l_gl_per_end_date DATE;
1237: l_gl_per_real_end_date DATE;
1238:
1239: l_gl_period_status gl_period_statuses.closing_status%TYPE;
1240: l_gl_period_status_2 gl_period_statuses.closing_status%TYPE;
1241:
1242: l_closed_per_ind NUMBER(2) := 0;
1243: l_crev_gl_trans_date DATE;

Line 1240: l_gl_period_status_2 gl_period_statuses.closing_status%TYPE;

1236: l_gl_per_end_date DATE;
1237: l_gl_per_real_end_date DATE;
1238:
1239: l_gl_period_status gl_period_statuses.closing_status%TYPE;
1240: l_gl_period_status_2 gl_period_statuses.closing_status%TYPE;
1241:
1242: l_closed_per_ind NUMBER(2) := 0;
1243: l_crev_gl_trans_date DATE;
1244: l_crev_gl_date DATE;