DBA Data[Home] [Help]

APPS.GL_JE_HEADERS_PKG dependencies on DUAL

Line 38: FROM dual;

34:
35: FUNCTION get_unique_id RETURN NUMBER IS
36: CURSOR get_new_id IS
37: SELECT gl_je_headers_s.NEXTVAL
38: FROM dual;
39: new_id number;
40: BEGIN
41: OPEN get_new_id;
42: FETCH get_new_id INTO new_id;

Line 674: FROM dual

670:
671: FUNCTION has_seqnum(batch_id NUMBER) RETURN BOOLEAN IS
672: CURSOR check_seqnum IS
673: SELECT 1
674: FROM dual
675: WHERE EXISTS (
676: SELECT 'has seqnum'
677: FROM gl_je_headers jeh
678: WHERE jeh.je_batch_id = batch_id