APPS.RG_DSS_VARIABLES_PKG dependencies on DUAL

Line 11: FROM sys.dual;

7: new_id NUMBER;
8: BEGIN
9: SELECT rg_dss_variables_s.nextval
10: INTO new_id
11: FROM sys.dual;
12:
13: RETURN(new_id);
14: END get_new_id;
15:

Line 36: FROM dual

32: /* The line "svr.system_id > 0" is added in the query to force the query
33: to use the index on system_id and variable_id for svr. */
34: SELECT 1
35: INTO dummy
36: FROM dual
37: WHERE NOT EXISTS
38: (SELECT 1
39: FROM rg_dss_systems sys,
40: rg_dss_system_variables svr

Line 61: FROM dual

57: BEGIN
58: /* Raise exception if there is no time dimension defined for this variable */
59: SELECT 1
60: INTO dummy
61: FROM dual
62: WHERE NOT EXISTS
63: (SELECT 1
64: FROM rg_dss_var_dimensions vdm,
65: rg_dss_dimensions dim

Line 79: FROM dual

75:
76: IF (X_Level_Code = 'S') THEN
77: SELECT 1
78: INTO dummy
79: FROM dual
80: WHERE NOT EXISTS
81: (SELECT 1
82: FROM rg_dss_var_dimensions vdm,
83: rg_dss_dimensions dim

Line 145: FROM dual

141: dummy NUMBER;
142: BEGIN
143: SELECT 1
144: INTO dummy
145: FROM dual
146: WHERE NOT EXISTS
147: (SELECT 1
148: FROM rg_dss_system_variables
149: WHERE variable_id = X_Variable_Id