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 410: FROM gl_period_statuses

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

Line 446: FROM gl_period_statuses

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

Line 2745: FROM gl_period_statuses

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

Line 2755: FROM gl_period_statuses

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

Line 2766: l_period_status gl_period_statuses.closing_status%TYPE;

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