APPS.HRI_OLTP_EMB_EQTY_ANAL dependencies on HRI_CS_SUPH

Line 76: FROM hri_cs_suph suph

72: IS
73:
74: CURSOR cur_sup_chk IS
75: SELECT 1
76: FROM hri_cs_suph suph
77: WHERE trunc(p_effective_date) BETWEEN suph.effective_start_date AND effective_end_date
78: AND suph.sup_person_id = p_top_mgr_person_id
79: AND suph.sub_person_id = p_lower_mgr_person_id
80: AND suph.sub_invalid_flag_code = 'N';