28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , per_scorecard_sharing psh
32: , per_all_people_f ppf
33: where psh.sharing_instance_id = p_sharing_instance_id
34: and psh.person_id = ppf.person_id
35: and ppf.business_group_id = pbg.business_group_id;
36: --
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups_perf pbg
103: , per_scorecard_sharing psh
104: , per_all_people_f ppf
105: where psh.sharing_instance_id = p_sharing_instance_id
106: and psh.person_id = ppf.person_id
107: and ppf.business_group_id = pbg.business_group_id;
108: --
475: --
476: Cursor csr_person_valid
477: is
478: select 'Y'
479: from per_all_people_f
480: where person_id = p_person_id
481: and trunc(sysdate) between
482: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
483: --