DBA Data[Home] [Help]

APPS.GL_ELIMINATION_SETS_PKG dependencies on DUAL

Line 27: FROM dual;

23: FUNCTION get_unique_id RETURN NUMBER IS
24:
25: CURSOR get_new_id IS
26: SELECT gl_elimination_sets_s.NEXTVAL
27: FROM dual;
28: new_id number;
29:
30: BEGIN
31: OPEN get_new_id;

Line 127: FROM DUAL

123: counter NUMBER;
124:
125: CURSOR name_count IS
126: SELECT 1
127: FROM DUAL
128: WHERE EXISTS (SELECT 1
129: FROM gl_elimination_sets
130: WHERE name = X_name
131: AND ledger_id = X_ledgerid

Line 179: FROM DUAL

175: counter NUMBER;
176:
177: CURSOR set_count IS
178: SELECT 1
179: FROM DUAL
180: WHERE EXISTS (SELECT 1
181: FROM gl_elimination_sets
182: WHERE elimination_set_id = X_setid
183: AND track_elimination_status_flag = 'Y'