VIEW: APPS.FII_CC_MGR_SUP_V

Source

View Text - Preformatted

SELECT peo.value, asg.emp_id, asg.mgr_id from hri_dbi_cl_per_n_v peo, fii_cc_mgr_hierarchies asg WHERE asg.emp_id = peo.id and trunc(sysdate) between peo.effective_start_date and peo.effective_end_date and (MGR_LEVEL = EMP_LEVEL or mgr_level = emp_level-1)

View Text - HTML Formatted

SELECT PEO.VALUE
, ASG.EMP_ID
, ASG.MGR_ID
FROM HRI_DBI_CL_PER_N_V PEO
, FII_CC_MGR_HIERARCHIES ASG
WHERE ASG.EMP_ID = PEO.ID
AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND (MGR_LEVEL = EMP_LEVEL OR MGR_LEVEL = EMP_LEVEL-1)