APPS.HRI_DBI_WMV_SEPARATION dependencies on HRI_CS_SUPH_V

Line 72: FROM hri_cs_suph_v

68: ) IS
69: SELECT sup_person_id,
70: sub_relative_level,
71: 0 row_number
72: FROM hri_cs_suph_v
73: WHERE sub_person_id = cp_sup_id
74: AND sub_relative_level > 0
75: AND cp_eff_dt BETWEEN effective_start_date AND effective_end_date
76: ORDER BY sub_relative_level ASC;