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.FV_UTILITY dependencies on GL_PERIOD_STATUSES

Line 439: FROM gl_period_statuses a, gl_period_statuses b

435:
436:
437: SELECT a.period_name
438: INTO tfirst_period
439: FROM gl_period_statuses a, gl_period_statuses b
440: WHERE a.application_id = 101
441: AND b.application_id = 101
442: AND a.ledger_id = tset_of_books_id
443: AND b.ledger_id = tset_of_books_id

Line 449: FROM gl_period_statuses c

445: AND a.period_year = b.period_year
446: AND b.period_name = tperiod_name
447: AND a.period_num =
448: (SELECT min(c.period_num)
449: FROM gl_period_statuses c
450: WHERE c.application_id = 101
451: AND c.ledger_id = tset_of_books_id
452: AND c.period_year = a.period_year
453: AND c.period_type = a.period_type

Line 702: FROM Gl_Period_Statuses

698:
699: BEGIN /* From Period Start Date */
700: SELECT start_date
701: INTO period_start_date
702: FROM Gl_Period_Statuses
703: WHERE ledger_id = sob_id
704: AND application_id = 101
705: AND period_year = period_year
706: AND period_name = period_from

Line 729: FROM Gl_Period_Statuses

725:
726: BEGIN /* To Period End Date */
727: SELECT end_date
728: INTO period_end_date
729: FROM Gl_Period_Statuses
730: WHERE ledger_id = sob_id
731: AND application_id = 101
732: AND period_year = period_year
733: AND period_name = period_to