871: --
872: -- cursor to fetch the batch description
873: CURSOR cur_batch_desc IS
874: SELECT batch_description
875: FROM igs_en_reg_btch_int
876: WHERE batch_id = p_batch_id;
877:
878: --
879: -- cursor to fetch the prefered person ID type
911: SELECT count(*)
912: FROM igs_en_reg_upd_int int
913: WHERE int.batch_id = p_batch_id ;
914:
915: l_batch_desc igs_en_reg_btch_int.batch_description%TYPE;
916: l_pref_per_type igs_pe_person_id_typ.person_id_type%TYPE;
917: l_person_id igs_pe_person_base_v.person_id%TYPE;
918: l_full_name igs_pe_person_base_v.full_name%TYPE;
919: l_alt_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;