APPS.PER_ORG_STRUCTURE_ELEMENTS_PKG dependencies on DUAL

Line 86: from sys.dual

82: -- Then return true else return false
83: --
84: select null
85: into l_temp
86: from sys.dual
87: where exists (select null
88: from sys.dual
89: where p_organization_id in
90: (select a.organization_id_child

Line 88: from sys.dual

84: select null
85: into l_temp
86: from sys.dual
87: where exists (select null
88: from sys.dual
89: where p_organization_id in
90: (select a.organization_id_child
91: from per_org_structure_elements a
92: where ( a.business_group_id + 0 = p_business_group_id

Line 206: from sys.dual

202: --
203: begin
204: select null
205: into l_temp
206: from sys.dual
207: where exists (select null
208: from per_org_structure_elements ose
209: where ose.org_structure_version_id =
210: p_org_structure_version_id

Line 237: from sys.dual

233: if p_hr_installed = 'I' then
234: begin
235: select null
236: into l_temp
237: from sys.dual
238: where exists( select null
239: from per_security_profiles psp
240: where psp.include_top_organization_flag = 'Y'
241: and psp.organization_structure_id =

Line 375: from sys.dual

371: -- Duplicate subordinate name? (Child can only have one parent)
372: --
373: select null
374: into l_temp
375: from sys.dual
376: where exists( select null
377: from per_org_structure_elements ose
378: where ose.org_structure_version_id =
379: p_org_structure_version_id

Line 406: from sys.dual

402: -- Is the Organization structure element effective as of start date
403: --
404: select null
405: into l_temp
406: from sys.dual
407: where exists(select null
408: from hr_all_organization_units org
409: where org.organization_id = p_org_id_parent
410: and p_date_from between

Line 474: from sys.dual

470: -- Still in the hierarchy?
471: --
472: select null
473: into l_temp
474: from sys.dual
475: where exists( select null
476: from per_org_structure_elements ose
477: where ose.org_structure_version_id =
478: p_org_structure_version_id

Line 571: CURSOR C2 IS SELECT per_org_structure_elements_s.nextval FROM sys.dual;

567: ) IS
568: --
569: CURSOR C IS SELECT rowid FROM PER_ORG_STRUCTURE_ELEMENTS
570: WHERE org_structure_element_id = p_Org_Structure_Element_Id;
571: CURSOR C2 IS SELECT per_org_structure_elements_s.nextval FROM sys.dual;
572: --
573: cursor get_details is select rowid,org_structure_element_id,
574: business_group_id,organization_id_parent,org_structure_version_id,
575: organization_id_child, position_control_enabled_flag