88: l_valid varchar2(150);
89: --
90: cursor legsel is
91: select pbg.legislation_code
92: from per_business_groups pbg,
93: per_assignments_f asg
94: where pbg.business_group_id = asg.business_group_id
95: and asg.assignment_id = p_assignment_id
96: and p_effective_date between asg.effective_start_date
273: l_valid varchar2(150);
274: --
275: cursor legsel is
276: select pbg.legislation_code
277: from per_business_groups pbg,
278: pay_personal_payment_methods_f ppm
279: where pbg.business_group_id = ppm.business_group_id
280: and ppm.personal_payment_method_id = p_personal_payment_method_id
281: and p_effective_date between ppm.effective_start_date