APPS.GL_PERIOD_STATUSES_PKG dependencies on GL_PERIODS

Line 22: FROM gl_periods

18: ending DATE;
19:
20: CURSOR period_set IS
21: SELECT min(start_date) begins, max(end_date) ends
22: FROM gl_periods
23: WHERE period_set_name = x_periodsetname
24: AND period_type = x_periodtype;
25:
26: CURSOR gap_exists IS

Line 258: GL_PERIODS p

254: p.period_year*10000 + p.period_num,
255: 'N'
256: FROM
257: GL_APPLICATION_GROUPS ag,
258: GL_PERIODS p
259: WHERE p.period_set_name = x_period_set_name
260: AND p.period_type = x_accounted_period_type
261: AND ag.group_name = 'PERIOD_STATUS'
262: AND EXISTS ( SELECT 'Application Installed'

Line 338: GL_PERIODS GP,

334: GP.year_start_date,
335: GP.period_year*10000 + GP.period_num,
336: 'N'
337: FROM
338: GL_PERIODS GP,
339: GL_LEDGERS LD
340: WHERE GP.period_set_name = nvl(x_period_set_name, LD.period_set_name)
341: AND GP.period_name = x_period_name
342: AND LD.ledger_id = x_ledger_id;

Line 835: select quarter_num from gl_periods

831: and period_num = (select max(glps.period_num)
832: from gl_period_statuses glps
833: where glps.closing_status in ('O','C','P')
834: and glps.quarter_num = (
835: select quarter_num from gl_periods
836: where period_name = x_period_name
837: and period_set_name = x_period_set_name)
838: and glps.period_year = x_period_year
839: and glps.application_id = 101

Line 842: /* Removed the redundant join to the GL_PERIODS table

838: and glps.period_year = x_period_year
839: and glps.application_id = 101
840: and glps.ledger_id = x_ledger_id
841: and glps.period_type = x_accounted_period_type );
842: /* Removed the redundant join to the GL_PERIODS table
843: for perf.bug Fix 2925883*/
844:
845:
846: BEGIN