1006: and paa.assignment_id=pac.assignment_id;
1007:
1008: CURSOR cur_sex(l_person_id number) IS
1009: SELECT per.sex 1010: FROM per_all_people_f per 1011: WHERE per.person_id = l_person_id;
1012:
1013: CURSOR cur_asg_count IS
1014: SELECT count(distinct pac.assignment_id),