24: -- Declare cursor
25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_process_events ppe
30: , per_all_assignments_f paa
31: where ppe.process_event_id = p_process_event_id
32: and ppe.assignment_id = paa.assignment_id
88: -- Declare cursor
89: --
90: cursor csr_leg_code is
91: select pbg.legislation_code
92: from per_business_groups pbg
93: , pay_process_events ppe
94: , per_all_assignments_f paa
95: where ppe.process_event_id = p_process_event_id
96: and ppe.assignment_id = paa.assignment_id