APPS.PER_ORG_STRUCTURE_VERSIONS_PKG dependencies on DUAL

Line 78: from sys.dual

74: --
75: begin
76: select null
77: into l_dummy
78: from sys.dual
79: where exists (select 1
80: from per_org_structure_versions osv
81: where osv.organization_structure_id = p_org_structure_id
82: and osv.version_number = p_version_number

Line 113: from sys.dual

109: --
110: begin
111: select null
112: into l_dummy
113: from sys.dual
114: where exists
115: (select 1
116: from per_org_structure_versions osv
117: where osv.organization_structure_id = p_org_structure_id

Line 148: from sys.dual

144: -- test for overlapping rows.
145: --
146: select null
147: into l_dummy
148: from sys.dual
149: where exists
150: (select 1
151: from per_org_structure_versions osv
152: where osv.date_from <= nvl(p_date_to,

Line 262: FROM sys.dual;

258: CURSOR C IS SELECT rowid
259: FROM PER_ORG_STRUCTURE_VERSIONS
260: WHERE org_structure_version_id = p_Org_Structure_Version_Id;
261: CURSOR C2 IS SELECT per_org_structure_versions_s.nextval
262: FROM sys.dual;
263: --
264: BEGIN
265: PER_ORG_STRUCTURE_VERSIONS_PKG.check_version_number(
266: p_org_structure_id => p_Organization_Structure_Id

Line 452: from sys.dual

448: begin
449: begin
450: select null
451: into l_dummy
452: from sys.dual
453: where exists ( select 1
454: from per_org_structure_elements ose
455: where ose.org_structure_version_id = p_org_Structure_Version_Id
456: );