APPS.PER_POS_STRUCTURE_VERSIONS_PKG dependencies on DUAL

Line 27: from sys.dual

23: l_dummy VARCHAR2(1);
24: begin
25: select null
26: into l_dummy
27: from sys.dual
28: where exists (select 1
29: from per_pos_structure_versions psv
30: where psv.position_structure_id = X_Position_Structure_Id
31: and psv.version_number = X_Version_Number

Line 114: from sys.dual

110: --
111: begin
112: select null
113: into l_dummy
114: from sys.dual
115: where exists
116: (select 1
117: from per_pos_structure_versions psv
118: where psv.position_structure_id = X_Position_Structure_Id

Line 149: from sys.dual

145: -- Test for overlapping rows
146: --
147: select null
148: into l_dummy
149: from sys.dual
150: where exists
151: (select 1
152: from per_pos_structure_versions psv
153: where psv.date_from <= nvl(X_Date_To, X_End_Of_Time)

Line 234: from sys.dual

230: begin
231: begin
232: select null
233: into l_dummy
234: from sys.dual
235: where exists( select null
236: from PER_POS_STRUCTURE_ELEMENTS PSE
237: where PSE.POS_STRUCTURE_VERSION_ID = X_Pos_Structure_Version_Id);
238: --

Line 249: from sys.dual

245: if X_Hr_Installed <> 'N' then
246: begin
247: select null
248: into l_dummy
249: from sys.dual
250: where exists(select null
251: from per_security_profiles
252: where business_group_id + 0 = X_Business_Group_Id
253: and position_structure_id = X_Position_Structure_Id);

Line 306: CURSOR C2 IS SELECT per_pos_structure_versions_s.nextval FROM sys.dual;

302: X_gap_warning IN OUT NOCOPY VARCHAR2
303: ) IS
304: CURSOR C IS SELECT rowid FROM PER_POS_STRUCTURE_VERSIONS
305: WHERE pos_structure_version_id = X_Pos_Structure_Version_Id;
306: CURSOR C2 IS SELECT per_pos_structure_versions_s.nextval FROM sys.dual;
307: BEGIN
308: --
309: PER_POS_STRUCTURE_VERSIONS_PKG.check_version_number(
310: X_Position_Structure_Id=> X_Position_Structure_Id