APPS.GL_DEFAS_ACCESS_SETS_PKG dependencies on DUAL

Line 11: FROM dual;

7:
8: FUNCTION get_unique_id RETURN NUMBER IS
9: CURSOR get_new_id IS
10: SELECT GL_DEFAS_ACCESS_SETS_S.NEXTVAL
11: FROM dual;
12: new_id NUMBER;
13: BEGIN
14: OPEN get_new_id;
15: FETCH get_new_id INTO new_id;

Line 40: FROM dual;

36:
37: FUNCTION get_dbname_id RETURN NUMBER IS
38: CURSOR get_new_id IS
39: SELECT GL_DEFAS_DBNAME_S.NEXTVAL
40: FROM dual;
41: new_id NUMBER;
42: BEGIN
43: OPEN get_new_id;
44: FETCH get_new_id INTO new_id;

Line 103: FROM DUAL

99: PROCEDURE check_assign (X_Definition_Access_Set_Id IN NUMBER,
100: X_Assign_Flag IN OUT NOCOPY VARCHAR2) IS
101: CURSOR assign IS
102: SELECT 'Y'
103: FROM DUAL
104: WHERE exists (
105: SELECT *
106: FROM gl_defas_resp_assign
107: WHERE definition_access_set_id = X_Definition_Access_Set_Id);