DBA Data[Home] [Help]

APPS.FII_SIZING_UTIL dependencies on GL_PERIODS

Line 445: From gl_periods per,

441:
442: CURSOR c_cnt_rows IS
443: select sum(cnt) from
444: (SELECT max(end_date)-min(per.start_date)+1 cnt
445: From gl_periods per,
446: gl_sets_of_books book
447: where per.start_date <= p_to_date
448: and per.end_date >= p_from_date
449: and per.ADJUSTMENT_PERIOD_FLAG = 'N'

Line 486: from gl_periods per, gl_sets_of_books book

482: per.period_year,
483: per.quarter_num,
484: per.start_date,
485: per.end_date
486: from gl_periods per, gl_sets_of_books book
487: where per.adjustment_period_flag = 'N'
488: and per.period_set_name = book.period_set_name
489: and per.period_type = book.accounted_period_type)
490: union all