DBA Data[Home] [Help]

APPS.FII_SIZING_UTIL dependencies on PA_IMPLEMENTATIONS_ALL

Line 456: pa_implementations_all pa,

452: Group By per.period_set_name, per.period_type
453: union all
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

Line 469: from pa_implementations_all pa,

465: and map.accounting_date <= p_to_date
466: and map.period_name <> 'NOT ASSIGNED'
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