APPS.GL_ACCESS_SETS_PKG dependencies on DUAL

Line 30: FROM dual;

26:
27: FUNCTION get_unique_id RETURN NUMBER IS
28: CURSOR get_new_id IS
29: SELECT GL_ACCESS_SETS_S.NEXTVAL
30: FROM dual;
31: new_id NUMBER;
32: BEGIN
33: OPEN get_new_id;
34: FETCH get_new_id INTO new_id;

Line 59: FROM dual

55: FUNCTION has_details_in_db (X_Access_Set_Id NUMBER) RETURN BOOLEAN IS
56: num NUMBER;
57: CURSOR details IS
58: SELECT 1
59: FROM dual
60: WHERE EXISTS (SELECT 1
61: FROM GL_ACCESS_SET_NORM_ASSIGN
62: WHERE access_set_id = X_Access_Set_Id
63: AND (status_code <> 'D' OR status_code IS NULL));