DBA Data[Home] [Help]

APPS.HRI_OPL_WRKFC_TRNSFR_EVENTS dependencies on HRI_CS_SUPH

Line 365: hri_cs_suph suph

361: SELECT
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