eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_SIZING_UTIL dependencies on GL_SETS_OF_BOOKS

Line 446: gl_sets_of_books book

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'
450: and per.period_set_name = book.period_set_name

Line 457: gl_sets_of_books gl,

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
461: and map.period_type=pa.pa_period_type

Line 470: gl_sets_of_books gl,

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
474: and period.end_date >= p_from_date

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