105:
106:
107:
108: CURSOR csr_legislation
109: (c_assignment_id per_assignments_f.assignment_id%TYPE
110: ,c_effective_date DATE)
111: IS
112: SELECT NULL
113: FROM per_assignments_f asg,
109: (c_assignment_id per_assignments_f.assignment_id%TYPE
110: ,c_effective_date DATE)
111: IS
112: SELECT NULL
113: FROM per_assignments_f asg,
114: per_business_groups bgp
115: WHERE asg.business_group_id = bgp.business_group_id
116: AND asg.assignment_id = c_assignment_id
117: AND c_effective_date BETWEEN effective_start_date AND effective_end_date
380: --
381: -- Declare cursors
382: --
383: CURSOR csr_legislation
384: (c_person_id per_assignments_f.person_id%TYPE
385: ,c_effective_date DATE)
386: IS
387: SELECT NULL
388: FROM per_assignments_f paf,
384: (c_person_id per_assignments_f.person_id%TYPE
385: ,c_effective_date DATE)
386: IS
387: SELECT NULL
388: FROM per_assignments_f paf,
389: per_business_groups pbg
390: WHERE paf.person_id = c_person_id
391: AND c_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
392: AND pbg.business_group_id = paf.business_group_id