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

Line 116: FROM gl_period_statuses

112: -------------------------------------------------------------------------------
113: --get gl date from open accounting period
114: CURSOR c_get_gl_date(cp_date IN DATE) IS SELECT * from (
115: SELECT trunc(cp_date) gl_date, 1 Counter
116: FROM gl_period_statuses
117: WHERE application_id = 222
118: -- BEGIN abindal bug 4356410 --
119: AND closing_status IN ('F','O')
120: -- END abindal bug 4356410 --

Line 126: FROM gl_period_statuses

122: AND trunc(cp_date) between start_date and end_date
123: AND adjustment_period_flag = 'N'
124: UNION
125: SELECT MAX(end_date) gl_date, 2 Counter
126: FROM gl_period_statuses
127: WHERE application_id = 222
128: AND ledger_id = okl_accounting_util.get_set_of_books_id
129: AND closing_status IN ('F','O')
130: AND end_date <= trunc(cp_date)

Line 134: FROM gl_period_statuses

130: AND end_date <= trunc(cp_date)
131: AND adjustment_period_flag = 'N'
132: UNION
133: SELECT MIN(start_date) gl_date, 3 Counter
134: FROM gl_period_statuses
135: WHERE application_id = 222
136: AND ledger_id = okl_accounting_util.get_set_of_books_id
137: AND closing_status IN ('F','O')
138: AND start_date >= trunc(cp_date)