664: l_assignment_id number;
665: --
666: cursor c_assignment is
667: select paf.assignment_id
668: from per_all_assignments_f paf, per_assignment_status_types pat
669: where paf.primary_flag = 'Y'
670: and paf.assignment_type <> 'C'
671: and paf.business_group_id = p_business_group_id
672: and paf.person_id = p_person_id
682: order by assignment_type desc, effective_start_date desc;
683: --
684: cursor c_all_assignment is
685: select paf.assignment_id
686: from per_all_assignments_f paf, per_assignment_status_types pat
687: where paf.primary_flag = 'Y'
688: and paf.assignment_type <> 'C'
689: and paf.business_group_id = p_business_group_id
690: and paf.person_id = p_person_id