[Home] [Help]
253: p.year_start_date,
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'
417: x_year_start_date,
418: x_period_year * 10000 + x_period_num,
419: 'N'
420: FROM
421: GL_APPLICATION_GROUPS ag,
422: GL_LEDGERS led
423: WHERE ag.group_name = 'PERIOD_STATUS'
424: AND led.period_set_name = x_calendar_name
425: AND led.accounted_period_type = x_period_type