APPS.HRI_OPL_WRKFC_ORGMGR dependencies on HRI_MB_ASGN_EVENTS_CT

Line 217: hri_mb_asgn_events_ct evts

213: ,1 metric_adjust_multiplier
214: ,orgmgr.sup_level supervisor_level
215: ,sub_assignment_id sub_assignment_id
216: FROM
217: hri_mb_asgn_events_ct evts
218: ,hri_cs_suph_orgmgr_ct orgmgr
219: WHERE orgmgr.sub_person_id = evts.supervisor_id
220: AND (evts.effective_change_date BETWEEN orgmgr.effective_start_date AND orgmgr.effective_end_date
221: OR orgmgr.effective_start_date BETWEEN evts.effective_change_date AND evts.effective_change_end_date)

Line 245: hri_mb_asgn_events_ct evts

241: ,-1 metric_adjust_multiplier
242: ,orgmgr.sup_level supervisor_level
243: ,sub_assignment_id sub_assignment_id
244: FROM
245: hri_mb_asgn_events_ct evts
246: ,hri_cs_suph_orgmgr_ct orgmgr
247: WHERE orgmgr.sub_person_id = evts.supervisor_id
248: AND (orgmgr.effective_end_date BETWEEN evts.effective_change_date AND evts.effective_change_end_date
249: OR evts.effective_change_end_date BETWEEN orgmgr.effective_start_date AND orgmgr.effective_end_date)

Line 419: FROM hri_mb_asgn_events_ct asg_evt

415: --
416: p_sqlstr :=
417: 'SELECT /*+ parallel (ASG_EVT, default, default) */
418: DISTINCT person_id object_id
419: FROM hri_mb_asgn_events_ct asg_evt
420: ORDER BY person_id';
421: --
422: -- End of Full Refresh Section
423: -- -------------------------------------------------------------------------