APPS.GL_JE_BATCHES_PKG dependencies on DUAL

Line 49: FROM dual;

45:
46: FUNCTION get_unique_id RETURN NUMBER IS
47: CURSOR get_new_id IS
48: SELECT gl_je_batches_s.NEXTVAL
49: FROM dual;
50: new_id number;
51: BEGIN
52: OPEN get_new_id;
53: FETCH get_new_id INTO new_id;

Line 78: FROM dual

74:
75: FUNCTION has_lines(batch_id NUMBER) RETURN BOOLEAN IS
76: CURSOR chk_batch IS
77: SELECT 'Has Lines'
78: FROM dual
79: WHERE EXISTS (SELECT 'Found Line'
80: FROM gl_je_headers jeh, gl_je_lines jel
81: WHERE jeh.je_batch_id = batch_id
82: AND jel.je_header_id = jeh.je_header_id);

Line 109: FROM dual

105:
106: FUNCTION needs_approval(batch_id NUMBER) RETURN BOOLEAN IS
107: CURSOR needs_apprvl IS
108: SELECT 'Needs Approval'
109: FROM dual
110: WHERE EXISTS (SELECT 'Needs Approval'
111: FROM gl_je_headers jeh, gl_ledgers lgr,
112: gl_je_sources src
113: WHERE jeh.je_batch_id = batch_id

Line 143: FROM dual

139:
140: FUNCTION needs_tax(batch_id NUMBER) RETURN BOOLEAN IS
141: CURSOR needstx IS
142: SELECT 'Needs Tax'
143: FROM dual
144: WHERE EXISTS (SELECT 'Needs Tax'
145: FROM gl_je_headers jeh, gl_ledgers lgr
146: WHERE jeh.je_batch_id = batch_id
147: AND jeh.tax_status_code = 'R'