APPS.INV_ORGHIERARCHY_PVT dependencies on DUAL

Line 184: ( SELECT l_sec_origin_org_id FROM DUAL WHERE l_include_origin_flag = 'Y')

180: arc.organization_id_parent = l_sec_origin_org_id
181: AND arc.org_structure_version_id = l_sec_hierarchy_version_id
182: )
183: UNION
184: ( SELECT l_sec_origin_org_id FROM DUAL WHERE l_include_origin_flag = 'Y')
185: )
186: ),
187: hr_all_organization_units org,
188: hr_organization_information hoi,