2594: order by a.effective_start_date asc, a.effective_end_date desc;
2595: --
2596: cursor c_pt is
2597: select person_type_id 2598: from per_person_types 2599: where system_person_type = 'PRTN'
2600: and business_group_id = p_business_group_id;
2601: --
2602: type pen_record is table of c_pen%rowtype index by binary_integer;