APPS.GMF_SUBLEDGER_PKG dependencies on GL_PERIODS

Line 1180: gl_periods glp,

1176: cp_fiscal_year NUMBER)
1177: IS
1178: SELECT DISTINCT glp.period_year
1179: FROM
1180: gl_periods glp,
1181: gl_period_sets gps,
1182: gl_sets_of_books gsb
1183: WHERE
1184: glp.period_year = cp_fiscal_year

Line 1199: gl_periods glp,

1195: IS
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

Line 1230: l_gl_period_name gl_periods.period_name%TYPE;

1226:
1227: l_temp_start_date DATE; -- 13797936
1228: l_temp_end_date DATE; -- 13797936
1229:
1230: l_gl_period_name gl_periods.period_name%TYPE;
1231: l_gl_period_year gl_periods.period_year%TYPE;
1232: l_gl_period_num gl_periods.period_num%TYPE;
1233:
1234: l_gl_per_start_date DATE;

Line 1231: l_gl_period_year gl_periods.period_year%TYPE;

1227: l_temp_start_date DATE; -- 13797936
1228: l_temp_end_date DATE; -- 13797936
1229:
1230: l_gl_period_name gl_periods.period_name%TYPE;
1231: l_gl_period_year gl_periods.period_year%TYPE;
1232: l_gl_period_num gl_periods.period_num%TYPE;
1233:
1234: l_gl_per_start_date DATE;
1235: l_gl_per_real_start_date DATE;

Line 1232: l_gl_period_num gl_periods.period_num%TYPE;

1228: l_temp_end_date DATE; -- 13797936
1229:
1230: l_gl_period_name gl_periods.period_name%TYPE;
1231: l_gl_period_year gl_periods.period_year%TYPE;
1232: l_gl_period_num gl_periods.period_num%TYPE;
1233:
1234: l_gl_per_start_date DATE;
1235: l_gl_per_real_start_date DATE;
1236: l_gl_per_end_date DATE;