APPS.RG_DSS_SEG_RANGE_SETS_PKG dependencies on DUAL

Line 34: FROM dual

30: dummy NUMBER;
31: BEGIN
32: SELECT 1
33: INTO dummy
34: FROM dual
35: WHERE NOT EXISTS
36: (SELECT 1
37: FROM rg_dss_seg_ranges
38: WHERE range_set_id = X_Range_Set_Id);

Line 53: FROM dual

49: dummy NUMBER;
50: BEGIN
51: SELECT 1
52: INTO dummy
53: FROM dual
54: WHERE NOT EXISTS
55: (SELECT 1
56: FROM rg_dss_dim_segments
57: WHERE range_set_id = X_Range_Set_Id

Line 62: FROM dual

58: );
59:
60: SELECT 1
61: INTO dummy
62: FROM dual
63: WHERE NOT EXISTS
64: (SELECT 1
65: FROM rg_dss_var_selections
66: WHERE range_set_id = X_Range_Set_Id

Line 81: FROM dual

77: dummy NUMBER;
78: BEGIN
79: SELECT 1
80: INTO dummy
81: FROM dual
82: WHERE NOT EXISTS
83: (SELECT 1
84: FROM rg_dss_systems sys,
85: rg_dss_system_variables svar,

Line 139: FROM dual;

135: WHERE range_set_id = X_Range_Set_Id;
136:
137: CURSOR C2 IS
138: SELECT rg_dss_seg_range_sets_s.nextval
139: FROM dual;
140:
141: BEGIN
142:
143: check_unique(X_Rowid, X_Name);