[Home] [Help]
APPS.HRI_EDW_DIM_PERSON dependencies on HRI_SUPV_HRCHY_SUMMARY
Line 15: FROM hri_supv_hrchy_summary
11: l_parent_id NUMBER;
12:
13: CURSOR parent_csr IS
14: SELECT supv_person_id
15: FROM hri_supv_hrchy_summary
16: WHERE sub_person_id = p_person_id
17: AND supv_level = 14;
18:
19: BEGIN