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

Line 213: x_gl_period gl_period_statuses.period_name%TYPE;

209: FUNCTION get_gl_period (
210: x_gl_date IN DATE
211: )
212: RETURN VARCHAR2 IS
213: x_gl_period gl_period_statuses.period_name%TYPE;
214: BEGIN
215:
216: SELECT gps.period_name
217: INTO x_gl_period

Line 218: FROM gl_period_statuses gps

214: BEGIN
215:
216: SELECT gps.period_name
217: INTO x_gl_period
218: FROM gl_period_statuses gps
219: WHERE x_gl_date between gps.start_date and gps.end_date
220: AND gps.application_id+0 = 101
221: AND gps.adjustment_period_flag||'' <> 'Y'
222: AND gps.set_of_books_id = pa_misc.get_set_of_books_id;