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_ADVANCED_CASH_APP_PVT dependencies on GL_PERIOD_STATUSES

Line 3354: FROM gl_period_statuses

3350:
3351: --get gl date from open accounting period
3352: CURSOR c_get_gl_date(cp_date IN DATE) IS SELECT * from (
3353: SELECT trunc(cp_date) gl_date, 1 Counter
3354: FROM gl_period_statuses
3355: WHERE application_id = 222
3356: -- BEGIN abindal bug 4356410 --
3357: AND closing_status IN ('F','O')
3358: -- END abindal bug 4356410 --

Line 3364: FROM gl_period_statuses

3360: AND trunc(cp_date) between start_date and end_date
3361: AND adjustment_period_flag = 'N'
3362: UNION
3363: SELECT MAX(end_date) gl_date, 2 Counter
3364: FROM gl_period_statuses
3365: WHERE application_id = 222
3366: AND ledger_id = okl_accounting_util.get_set_of_books_id
3367: AND closing_status IN ('F','O')
3368: AND end_date <= trunc(cp_date)

Line 3372: FROM gl_period_statuses

3368: AND end_date <= trunc(cp_date)
3369: AND adjustment_period_flag = 'N'
3370: UNION
3371: SELECT MIN(start_date) gl_date, 3 Counter
3372: FROM gl_period_statuses
3373: WHERE application_id = 222
3374: AND ledger_id = okl_accounting_util.get_set_of_books_id
3375: AND closing_status IN ('F','O')
3376: AND start_date >= trunc(cp_date)