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

Line 1793: FROM gl_period_statuses G

1789: l_gl_period VARCHAR2(30); -- size of 15 is enough
1790:
1791: CURSOR gl_period_csr (p_sob_id IN NUMBER, p_acc_date IN DATE) IS
1792: SELECT G.period_name
1793: FROM gl_period_statuses G
1794: WHERE G.application_id = 101
1795: AND G.closing_status in ('O', 'F')
1796: AND NVL(G.adjustment_period_flag, 'N') = 'N'
1797: AND G.set_of_books_id = p_sob_id

Line 3112: FROM gl_period_statuses a

3108:
3109: --Bug7391920 - Added cursor c_period_closed
3110: CURSOR c_period_closed ( l_acct_date DATE ) IS
3111: SELECT closing_status
3112: FROM gl_period_statuses a
3113: , ozf_sys_parameters b
3114: WHERE application_id = 222
3115: AND a.set_of_books_id = b.set_of_books_id
3116: AND l_acct_date BETWEEN start_date AND end_date

Line 3123: FROM gl_period_statuses a

3119:
3120: --Bug7391920 - Added cursor c_open_period
3121: CURSOR c_open_period IS
3122: SELECT MIN(start_date)
3123: FROM gl_period_statuses a
3124: , ozf_sys_parameters b
3125: WHERE a.application_id = 222
3126: AND a.set_of_books_id = b.set_of_books_id
3127: AND nvl(a.adjustment_period_flag,'N') = 'N'