DBA Data[Home] [Help]

APPS.FII_SIZING_UTIL dependencies on PA_PERIODS_ALL

Line 458: pa_periods_all period

454: select count(*)
455: from gl_date_period_map map,
456: pa_implementations_all pa,
457: gl_sets_of_books gl,
458: pa_periods_all period
459: where pa.set_of_books_id=gl.set_of_books_id
460: and period.org_id=pa.org_id
461: and map.period_type=pa.pa_period_type
462: and map.period_name=period.period_name

Line 471: pa_periods_all period

467: union all
468: select count(*)
469: from pa_implementations_all pa,
470: gl_sets_of_books gl,
471: pa_periods_all period
472: where pa.set_of_books_id=gl.set_of_books_id
473: and period.org_id=pa.org_id
474: and period.end_date >= p_from_date
475: and period.start_date <= p_to_date