DBA Data[Home] [Help]

APPS.PER_PERUSEOC_XMLP_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 432: HR_LOCATION_EXTRA_INFO HLEI1,

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

Line 433: HR_LOCATION_EXTRA_INFO HLEI2

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