24: ) is
25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_checklist_items chk
30: , per_all_people_f peo
31: where chk.checklist_item_id = p_checklist_item_id
32: and chk.person_id = peo.person_id
84: Return Varchar2 Is
85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , per_checklist_items chk
90: , per_all_people_f peo
91: where chk.checklist_item_id = p_checklist_item_id
92: and chk.person_id = peo.person_id