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

Line 409: FROM gl_period_statuses

405: l_ledger_id NUMBER;
406:
407: CURSOR sts_csr (l_ledger_id NUMBER) IS
408: SELECT closing_status
409: FROM gl_period_statuses
410: WHERE application_id = 540
411: AND ledger_id = l_ledger_id
412: AND period_name = p_period_name;
413:

Line 445: FROM gl_period_statuses

441: l_ledger_id NUMBER;
442:
443: CURSOR sts_csr (l_ledger_id NUMBER) IS
444: SELECT closing_status
445: FROM gl_period_statuses
446: WHERE application_id = 101
447: AND ledger_id = l_ledger_id
448: AND period_name = p_period_name;
449:

Line 2743: FROM gl_period_statuses

2739: AS
2740:
2741: CURSOR bef_csr (l_ledger_id NUMBER) IS
2742: SELECT MAX(end_date)
2743: FROM gl_period_statuses
2744: WHERE application_id = 540
2745: AND ledger_id = l_ledger_id
2746: AND closing_status IN ('F','O')
2747: AND TRUNC(end_date) <= TRUNC(p_gl_date)

Line 2753: FROM gl_period_statuses

2749:
2750:
2751: CURSOR aft_csr (l_ledger_id NUMBER) IS
2752: SELECT MIN(start_date)
2753: FROM gl_period_statuses
2754: WHERE application_id = 540
2755: AND ledger_id = l_ledger_id
2756: AND closing_status IN ('F','O')
2757: AND TRUNC(start_date) >= TRUNC(p_gl_date)

Line 2764: l_period_status gl_period_statuses.closing_status%TYPE;

2760: l_period_name gl_periods.period_name%TYPE;
2761: l_start_date DATE;
2762: l_end_date DATE;
2763: l_dummy_date DATE := NULL;
2764: l_period_status gl_period_statuses.closing_status%TYPE;
2765: l_ledger_id NUMBER;
2766:
2767:
2768: