19: cursor csr_bg_name
20: (p_person_id number,
21: p_effective_date date) is
22: select x.name
23: from per_business_groups x , per_all_people_f papf
24: where x.business_group_id = papf.business_group_id
25: and papf.person_id=p_person_id;
26: --
27: --Added for PMxbg
27: --Added for PMxbg
28: cursor csr_get_leg
29: (p_business_group_id number) is
30: select x.legislation_code
31: from per_business_groups x
32: where x.business_group_id=p_business_group_id;
33: --
34: cursor csr_template(p_legislation_code varchar2) is
35: select