DBA Data[Home] [Help]

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