DBA Data[Home] [Help]

APPS.HRI_OPL_ASGN_EVENTS dependencies on HRI_CS_SUPH

Line 482: ,hri_cs_suph suph

478: ,'ASG_EVENT_PREV'
479: FROM
480: hri_eq_asgn_evnts eq
481: ,hri_mb_asgn_events_ct evt
482: ,hri_cs_suph suph
483: WHERE eq.assignment_id = evt.assignment_id
484: AND evt.supervisor_id = suph.sub_person_id
485: AND eq.erlst_evnt_effective_date <= evt.effective_change_end_date
486: AND eq.erlst_evnt_effective_date - 1 <= suph.effective_end_date

Line 496: ,hri_cs_suph suph

492: ,'ASG_EVENT_CURR'
493: FROM
494: hri_eq_asgn_evnts eq
495: ,per_all_assignments_f asg
496: ,hri_cs_suph suph
497: WHERE eq.assignment_id = asg.assignment_id
498: AND eq.erlst_evnt_effective_date <= asg.effective_end_date
499: AND asg.supervisor_id = suph.sub_person_id
500: AND eq.erlst_evnt_effective_date <= suph.effective_end_date;