DBA Data[Home] [Help]

APPS.HRI_OPL_SUPH_HST dependencies on HRI_MB_WRKFC_EVT_CT

Line 259: ,hri_mb_wrkfc_evt_ct wevt

255: ,eq.erlst_evnt_effective_date
256: ,'ASG_MGR_' || eq.source_code
257: FROM
258: hri_eq_sprvsr_hrchy_chgs eq
259: ,hri_mb_wrkfc_evt_ct wevt
260: WHERE wevt.time_day_evt_end_fk >= eq.erlst_evnt_effective_date
261: AND wevt.per_person_mgr_fk = eq.person_id;
262:
263: INSERT INTO hri_eq_wrkfc_mnth

Line 273: ,hri_mb_wrkfc_evt_ct wevt

269: ,eq.erlst_evnt_effective_date
270: ,'ASG_MGR_' || eq.source_code
271: FROM
272: hri_eq_sprvsr_hrchy_chgs eq
273: ,hri_mb_wrkfc_evt_ct wevt
274: WHERE wevt.time_day_evt_end_fk >= eq.erlst_evnt_effective_date
275: AND wevt.per_person_mgr_fk = eq.person_id;
276:
277: -- commit