428: SELECT
429: ENTITY_ID
430: FROM
431: PER_GEN_HIERARCHY_NODES PGHN,
432: HR_LOCATION_EXTRA_INFO HLEI1,
433: HR_LOCATION_EXTRA_INFO HLEI2
434: WHERE PGHN.NODE_TYPE <> 'PAR'
435: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
436: AND TO_CHAR(HLEI1.LOCATION_ID) = PGHN.ENTITY_ID
429: ENTITY_ID
430: FROM
431: PER_GEN_HIERARCHY_NODES PGHN,
432: HR_LOCATION_EXTRA_INFO HLEI1,
433: HR_LOCATION_EXTRA_INFO HLEI2
434: WHERE PGHN.NODE_TYPE <> 'PAR'
435: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
436: AND TO_CHAR(HLEI1.LOCATION_ID) = PGHN.ENTITY_ID
437: AND TO_CHAR(HLEI2.LOCATION_ID) = PGHN.ENTITY_ID