DBA Data[Home] [Help]

APPS.GL_GLXAVADT_XMLP_PKG dependencies on GL_DATE_PERIOD_MAP

Line 229: gl_date_period_map dpm

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
233: -- AND dpm.period_type = PERIOD_TYPE

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