65:
66: CURSOR legsel (p_assignment_id IN NUMBER, p_effective_date IN DATE) IS
67: SELECT pbg.legislation_code
68: FROM per_business_groups pbg,
69: per_assignments_f asg
70: WHERE pbg.business_group_id = asg.business_group_id
71: AND asg.assignment_id = p_assignment_id
72: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;
73: