29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , hr_document_extra_info dei
33: , per_all_people_f ppf
34: where dei.document_extra_info_id = p_document_extra_info_id
35: and ppf.person_id = dei.person_id
36: and pbg.business_group_id = ppf.business_group_id;
37: --
101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: , hr_document_extra_info dei
105: , per_all_people_f ppf
106: where dei.document_extra_info_id = p_document_extra_info_id
107: and ppf.person_id = dei.person_id
108: and pbg.business_group_id = ppf.business_group_id;
109: --
172: --
173: cursor csr_leg_code is
174: select pbg.legislation_code
175: from per_business_groups_perf pbg
176: , per_all_people_f ppf
177: where ppf.person_id = p_person_id
178: and pbg.business_group_id = ppf.business_group_id;
179: --
180: -- Declare local variables