APPS.RG_REPORT_PARAMETERS_PKG dependencies on DUAL

Line 11: FROM dual;

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

Line 24: SELECT 1 INTO dummy FROM dual

20: RETURN BOOLEAN
21: IS
22: dummy NUMBER;
23: BEGIN
24: SELECT 1 INTO dummy FROM dual
25: WHERE NOT EXISTS
26: (SELECT 1 FROM rg_report_parameters
27: WHERE parameter_set_id = para_set_id
28: AND parameter_num = para_num

Line 47: FROM dual;

43: to_parameter_set_id NUMBER;
44: BEGIN
45: SELECT rg_report_parameters_s.nextval
46: INTO to_parameter_set_id
47: FROM dual;
48:
49: INSERT INTO rg_report_parameters
50: (parameter_set_id,
51: last_update_date,

Line 157: CURSOR C2 IS SELECT rg_report_parameters_s.nextval FROM dual;

153: WHERE parameter_set_id = X_Parameter_Set_Id
154: AND parameter_num = X_Parameter_Num
155: AND data_type = X_Data_Type;
156:
157: CURSOR C2 IS SELECT rg_report_parameters_s.nextval FROM dual;
158: BEGIN
159:
160: IF (X_Parameter_Set_Id is NULL) then
161: OPEN C2;