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 440: FROM gl_period_statuses a, gl_period_statuses b

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

Line 450: FROM gl_period_statuses c

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

Line 703: FROM Gl_Period_Statuses

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

Line 730: FROM Gl_Period_Statuses

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