28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , per_all_assignments_f paf
33: , per_personal_scorecards pms
34: where pms.scorecard_id = p_scorecard_id
35: and pms.assignment_id = paf.assignment_id
36: and paf.business_group_id = pbg.business_group_id;
101: --
102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups_perf pbg
105: , per_all_assignments_f paf
106: , per_personal_scorecards pms
107: where pms.scorecard_id = p_scorecard_id
108: and pms.assignment_id = paf.assignment_id
109: and paf.business_group_id = pbg.business_group_id;
463: --
464:
465: CURSOR csr_chk_assignment_id IS
466: SELECT asg.assignment_id, asg.person_id
467: FROM per_all_assignments_f asg
468: WHERE asg.assignment_id = p_assignment_id
469: AND asg.assignment_type <> 'B';
470: --
471: BEGIN