APPS.HR_ORGANIZATION_UNITS_PKG dependencies on DUAL

Line 174: from sys.dual

170: l_temp VARCHAR2(1) := 'N';
171: begin
172: select 'Y'
173: into l_temp
174: from sys.dual
175: where exists (select null
176: from per_org_structure_elements ose
177: where ose.org_structure_version_id =
178: p_org_structure_version_id

Line 370: CURSOR C2 IS SELECT hr_organization_units_s.nextval FROM sys.dual;

366: ) IS
367: CURSOR C IS SELECT rowid FROM HR_ALL_ORGANIZATION_UNITS
368: WHERE organization_id = X_Organization_Id;
369:
370: CURSOR C2 IS SELECT hr_organization_units_s.nextval FROM sys.dual;
371:
372: BEGIN
373: --
374: validate_business_group_name