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