APPS.HRI_OPL_WRKFC_TRNSFR_EVENTS dependencies on HRI_CS_MNGRSC_CT
Line 366: ,hri_cs_mngrsc_ct chn
362: suph.sup_person_id
363: ,chn.mgrs_mngrsc_pk
364: FROM
365: hri_cs_suph suph 366: ,hri_cs_mngrsc_ct chn 367: WHERE suph.sub_person_id = v_person_id
368: AND suph.sub_person_id = chn.mgrs_person_fk
369: AND v_date BETWEEN suph.effective_start_date
370: AND suph.effective_end_date