APPS.GL_JE_BATCHES_POST_PKG dependencies on DUAL

Line 17: FROM dual;

13:
14: FUNCTION get_unique_id RETURN NUMBER IS
15: CURSOR get_new_id IS
16: SELECT gl_je_posting_s.NEXTVAL
17: FROM dual;
18: new_id number;
19: BEGIN
20: OPEN get_new_id;
21: FETCH get_new_id INTO new_id;

Line 47: dual

43: CURSOR check_frozen IS
44: SELECT
45: 'BF'
46: FROM
47: dual
48: WHERE EXISTS
49: ( SELECT 'Frozen budget'
50: FROM GL_BUDGET_VERSIONS BV,
51: GL_JE_HEADERS JH

Line 60: dual

56: CURSOR check_unopened_year IS
57: SELECT
58: 'BU'
59: FROM
60: dual
61: WHERE EXISTS
62: ( SELECT 'Unopened budget year'
63: FROM GL_BUDGETS GB,
64: GL_BUDGET_VERSIONS BV,

Line 98: FROM SYS.DUAL

94:
95: FUNCTION check_unbal_monetary_headers (X_je_batch_id NUMBER) RETURN BOOLEAN IS
96: CURSOR chk_unbal_monetary_headers IS
97: SELECT 'Out of Balance'
98: FROM SYS.DUAL
99: WHERE EXISTS
100: ( SELECT 'x'
101: FROM GL_JE_HEADERS
102: WHERE je_batch_id = X_je_batch_id

Line 124: FROM SYS.DUAL

120:
121: FUNCTION check_untax_monetary_headers (X_je_batch_id NUMBER) RETURN BOOLEAN IS
122: CURSOR chk_untax_monetary_headers IS
123: SELECT 'Untaxed'
124: FROM SYS.DUAL
125: WHERE EXISTS
126: ( SELECT 'x'
127: FROM GL_JE_HEADERS
128: WHERE je_batch_id = X_je_batch_id