eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PERUSEOC_XMLP_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 398: HR_LOCATION_EXTRA_INFO HLEI1,

394: SELECT
395: ENTITY_ID
396: FROM
397: PER_GEN_HIERARCHY_NODES PGHN,
398: HR_LOCATION_EXTRA_INFO HLEI1,
399: HR_LOCATION_EXTRA_INFO HLEI2
400: WHERE PGHN.NODE_TYPE <> 'PAR'
401: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
402: AND TO_CHAR(HLEI1.LOCATION_ID) = PGHN.ENTITY_ID

Line 399: HR_LOCATION_EXTRA_INFO HLEI2

395: ENTITY_ID
396: FROM
397: PER_GEN_HIERARCHY_NODES PGHN,
398: HR_LOCATION_EXTRA_INFO HLEI1,
399: HR_LOCATION_EXTRA_INFO HLEI2
400: WHERE PGHN.NODE_TYPE <> 'PAR'
401: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
402: AND TO_CHAR(HLEI1.LOCATION_ID) = PGHN.ENTITY_ID
403: AND TO_CHAR(HLEI2.LOCATION_ID) = PGHN.ENTITY_ID