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.

[Home] [Help]

View: HRI_CL_PER_USRDR_H_V

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SHS.SUB_PERSON_ID ID
, PER.VALUE VALUE
, SHS.SUP_PERSON_ID PARANT_ID
, SHS.EFFECTIVE_START_DATE START_DATE
, SHS.EFFECTIVE_END_DATE END_DATE
, SHS.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, SHS.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
FROM HRI_CS_SUPH_V SHS
, HRI_CL_PER_V PER
WHERE SHS.SUB_PERSON_ID = PER.ID
AND PER.EMP_FLAG_CODE = 'Y'
AND SHS.SUB_RELATIVE_LEVEL <= 1
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE WITH READ ONLY

Columns

Name
ID
VALUE
PARENT_ID
START_DATE
END_DATE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE