[Home] [Help]
48: --
49: CURSOR legsel IS
50: SELECT pbg.legislation_code
51: FROM per_business_groups pbg,
52: per_assignments_f asg
53: WHERE pbg.business_group_id = asg.business_group_id
54: AND asg.assignment_id = p_assignment_id
55: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
56: --