DBA Data[Home] [Help]

APPS.GL_ENCUMBRANCE_TYPES_PKG dependencies on DUAL

Line 109: FROM dual;

105:
106: PROCEDURE get_unique_id (x_encumbrance_type_id IN OUT NOCOPY NUMBER) IS
107: CURSOR get_new_id IS
108: SELECT gl_encumbrance_types_s.NEXTVAL
109: FROM dual;
110: new_id number;
111: BEGIN
112: OPEN get_new_id;
113: FETCH get_new_id INTO x_encumbrance_type_id;

Line 209: FROM dual;

205: BEGIN
206: IF (x_encumbrance_type_id IS NULL) THEN
207: SELECT gl_encumbrance_types_s.nextval
208: INTO x_encumbrance_type_id
209: FROM dual;
210: END IF;
211:
212: IF (x_encumbrance_type_key IS NULL) THEN
213: x_encumbrance_type_key := to_char(x_encumbrance_type_id);