APPS.GL_GLXAVADT_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 202: FROM GL_PERIOD_STATUSES

198:
199: ELSE
200: SELECT min(start_date)
201: INTO min_startdate
202: FROM GL_PERIOD_STATUSES
203: WHERE application_id = 101
204: AND ledger_id = P_LEDGER_ID
205: -- AND period_year = PERIOD_YEAR
206: AND period_year = PERIOD_YEAR_1

Line 228: FROM gl_period_statuses ps,

224: AND dbal.currency_type = decode(P_CURRENCY_TYPE, 'E', 'E', 'U')
225: AND dbal.code_combination_id = CCID
226: AND dbal.accounting_date =
227: (SELECT ps.end_date
228: FROM gl_period_statuses ps,
229: gl_date_period_map dpm
230: WHERE dpm.accounting_date = (START_DATE -1)
231: -- AND dpm.period_set_name = PERIOD_SET_NAME
232: AND dpm.period_set_name = PERIOD_SET_NAME_1

Line 306: from gl_period_statuses ps, gl_date_period_map dpm

302: BEGIN
303:
304: select ps.period_year, ps.quarter_num, ps.period_num
305: into v_period_year, v_quarter_num, v_period_num
306: from gl_period_statuses ps, gl_date_period_map dpm
307: where dpm.accounting_date = reporting_date
308: and dpm.period_set_name = calendar_name
309: -- and dpm.period_type = PERIOD_TYPE
310: and dpm.period_type = PERIOD_TYPE_1

Line 340: from gl_period_statuses ps

336:
337: BEGIN
338: select ps.period_name, ps.start_date
339: into v_period_name, v_start_date
340: from gl_period_statuses ps
341: where ps.application_id = 101
342: and ps.ledger_id = ldgrid
343: and ps.adjustment_period_flag = 'N'
344: and ps.start_date =

Line 346: from gl_period_statuses ps1

342: and ps.ledger_id = ldgrid
343: and ps.adjustment_period_flag = 'N'
344: and ps.start_date =
345: (select min(ps1.start_date)
346: from gl_period_statuses ps1
347: where ps1.application_id = 101
348: and ps1.ledger_id = ldgrid
349: and ps1.period_year = v_period_year
350: and ps1.quarter_num = decode(balance_type,