VIEW: APPS.HRI_CL_PER_CCMGR_V

Source

View Text - Preformatted

SELECT per.id ID , per.value VALUE , suph.sup_person_id , per.effective_start_date , per.effective_end_date , suph.sup_person_id , suph.sub_person_id , suph.sup_absolute_level , suph.sub_absolute_level , suph.sub_relative_level FROM hri_cl_per_v per , hri_cs_suph_x_v suph WHERE suph.sub_person_id = per.id AND trunc(sysdate) BETWEEN per.effective_start_date AND per.effective_end_date /* Test whether subordinate is a cost centre manager */ /* Hint added by performance team */ AND EXISTS (SELECT /*+ no_unnest */ 1 FROM hri_cs_per_orgcc_ct ccmgr WHERE ccmgr.cc_mngr_person_id = suph.sub_person_id AND TRUNC(SYSDATE) BETWEEN ccmgr.effective_start_date AND ccmgr.effective_end_date ) WITH READ ONLY

View Text - HTML Formatted

SELECT PER.ID ID
, PER.VALUE VALUE
, SUPH.SUP_PERSON_ID
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, SUPH.SUP_PERSON_ID
, SUPH.SUB_PERSON_ID
, SUPH.SUP_ABSOLUTE_LEVEL
, SUPH.SUB_ABSOLUTE_LEVEL
, SUPH.SUB_RELATIVE_LEVEL
FROM HRI_CL_PER_V PER
, HRI_CS_SUPH_X_V SUPH
WHERE SUPH.SUB_PERSON_ID = PER.ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE /* TEST WHETHER SUBORDINATE IS A COST CENTRE MANAGER */ /* HINT ADDED BY PERFORMANCE TEAM */
AND EXISTS (SELECT /*+ NO_UNNEST */ 1
FROM HRI_CS_PER_ORGCC_CT CCMGR
WHERE CCMGR.CC_MNGR_PERSON_ID = SUPH.SUB_PERSON_ID
AND TRUNC(SYSDATE) BETWEEN CCMGR.EFFECTIVE_START_DATE
AND CCMGR.EFFECTIVE_END_DATE ) WITH READ ONLY