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_CCMGR_V

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

View Text

SELECT CCPEO.PERSON_ID ID
, CCPEO.FULL_NAME VALUE
, ASG.SUPERVISOR_ID PARENT_ID
, CCPEO.EFFECTIVE_START_DATE START_DATE
, CCPEO.EFFECTIVE_END_DATE END_DATE
, SHR1.SUP_PERSON_ID SUP_PERSON_ID
FROM HRI_CS_SUPH_V SHR1
, PER_PEOPLE_F CCPEO
, PER_ASSIGNMENTS_F ASG
WHERE TRUNC(SYSDATE) BETWEEN SHR1.EFFECTIVE_START_DATE
AND SHR1.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN CCPEO.EFFECTIVE_START_DATE
AND CCPEO.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASG.PERSON_ID = SHR1.SUB_PERSON_ID
AND ASG.PRIMARY_FLAG = 'Y'
AND CCPEO.PERSON_ID = SHR1.SUB_PERSON_ID
AND EXISTS ( SELECT PERSON_ID
FROM PER_PEOPLE_F PEO1
WHERE TRUNC(SYSDATE) BETWEEN PEO1.EFFECTIVE_START_DATE
AND PEO1.EFFECTIVE_END_DATE
AND PEO1.CURRENT_EMPLOYEE_FLAG = 'Y'
AND SHR1.SUB_PERSON_ID = PEO1.PERSON_ID
AND EXISTS ( SELECT PEO.PERSON_ID
FROM HR_ORGANIZATION_INFORMATION OINF
, PER_PEOPLE_F PEO
, HR_ALL_ORGANIZATION_UNITS ORG
, HRI_CS_SUPH_V SHR
WHERE OINF.ORG_INFORMATION_CONTEXT = 'ORGANIZATION NAME ALIAS'
AND ORG.ORGANIZATION_ID = OINF.ORGANIZATION_ID
AND OINF.ORG_INFORMATION2 = PEO.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN SHR.EFFECTIVE_START_DATE
AND SHR.EFFECTIVE_END_DATE
AND SHR.SUB_PERSON_ID = PEO.PERSON_ID ) )
AND SHR1.SUB_RELATIVE_LEVEL <=1 WITH READ ONLY

Columns

Name
ID
VALUE
PARENT_ID
START_DATE
END_DATE
SUP_PERSON_ID