DBA Data[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