DBA Data[Home] [Help]

APPS.GHR_FEHB_PLAN_DESIGN dependencies on PER_ALL_ASSIGNMENTS_F

Line 728: per_all_assignments_f asg

724:
725:
726: FROM pay_element_entries_f eef,
727: pay_element_types_f elt,
728: per_all_assignments_f asg
729: WHERE eef.assignment_id = asg.assignment_id
730: and elt.element_type_id = eef.element_type_id
731: AND eef.effective_start_date BETWEEN elt.effective_start_date AND elt.effective_end_date
732: AND eef.effective_start_date BETWEEN asg.effective_start_date AND asg.effective_end_date