VIEW: APPS.HRI_DBI_CL_PER_MGR_LVL_V

Source

View Text - Preformatted

SELECT suph.sup_person_id id ,peo.value ||'('|| suph.sup_person_id||')' value ,suph.sup_level sup_level ,peo.order_by order_by FROM hri_cl_wkr_sup_status_ct stt ,hri_cs_suph suph ,hri_cl_per_n_v peo WHERE stt.person_id = suph.sub_person_id AND stt.person_id = peo.id AND stt.supervisor_flag = 'Y' AND suph.sub_invalid_flag_code = 'N' AND suph.sub_relative_level = 0 AND TRUNC(SYSDATE) BETWEEN stt.effective_start_date AND stt.effective_end_date AND TRUNC(SYSDATE) BETWEEN suph.effective_start_date AND suph.effective_end_date AND TRUNC(SYSDATE) BETWEEN peo.effective_start_date AND peo.effective_end_date WITH READ ONLY

View Text - HTML Formatted

SELECT SUPH.SUP_PERSON_ID ID
, PEO.VALUE ||'('|| SUPH.SUP_PERSON_ID||')' VALUE
, SUPH.SUP_LEVEL SUP_LEVEL
, PEO.ORDER_BY ORDER_BY
FROM HRI_CL_WKR_SUP_STATUS_CT STT
, HRI_CS_SUPH SUPH
, HRI_CL_PER_N_V PEO
WHERE STT.PERSON_ID = SUPH.SUB_PERSON_ID
AND STT.PERSON_ID = PEO.ID
AND STT.SUPERVISOR_FLAG = 'Y'
AND SUPH.SUB_INVALID_FLAG_CODE = 'N'
AND SUPH.SUB_RELATIVE_LEVEL = 0
AND TRUNC(SYSDATE) BETWEEN STT.EFFECTIVE_START_DATE
AND STT.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN SUPH.EFFECTIVE_START_DATE
AND SUPH.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE WITH READ ONLY