13051: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
13052:
13053: -- Get get group description for group_id
13054: CURSOR c_person_group(
13055: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE
13056: ) IS
13057: SELECT group_cd group_name
13058: FROM igs_pe_persid_group_all
13059: WHERE group_id = cp_persid_grp;
13054: CURSOR c_person_group(
13055: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE
13056: ) IS
13057: SELECT group_cd group_name
13058: FROM igs_pe_persid_group_all
13059: WHERE group_id = cp_persid_grp;
13060:
13061: l_persid_grp_name c_person_group%ROWTYPE;
13062: