DBA Data[Home] [Help]

APPS.HRI_OPL_ASGN_EVENTS dependencies on HRI_CS_ORGH_CT

Line 437: ,hri_cs_orgh_ct orgh

433: ,GREATEST(eq.erlst_evnt_effective_date, evt.effective_change_date)
434: FROM
435: hri_eq_asgn_evnts eq
436: ,hri_mb_asgn_events_ct evt
437: ,hri_cs_orgh_ct orgh
438: WHERE eq.assignment_id = evt.assignment_id
439: AND eq.erlst_evnt_effective_date <= evt.effective_change_end_date
440: AND evt.organization_id = orgh.orgh_organztn_fk
441: UNION ALL

Line 449: ,hri_cs_orgh_ct orgh

445: ,GREATEST(eq.erlst_evnt_effective_date, asg.effective_start_date)
446: FROM
447: hri_eq_asgn_evnts eq
448: ,per_all_assignments_f asg
449: ,hri_cs_orgh_ct orgh
450: WHERE eq.assignment_id = asg.assignment_id
451: AND eq.erlst_evnt_effective_date <= asg.effective_end_date
452: AND asg.organization_id = orgh.orgh_organztn_fk;
453: