176: FROM IGS_PE_PERSON_BASE_V
177: WHERE person_id = p_person_id;
178: get_pers_num_rec cur_get_pers_num%ROWTYPE;
179:
180: CURSOR cur_get_base ( p_cal_type igs_ca_inst_all.cal_type%TYPE,
181: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
182: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
183: SELECT base_id
184: FROM IGF_AP_FA_BASE_REC_ALL
177: WHERE person_id = p_person_id;
178: get_pers_num_rec cur_get_pers_num%ROWTYPE;
179:
180: CURSOR cur_get_base ( p_cal_type igs_ca_inst_all.cal_type%TYPE,
181: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
182: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
183: SELECT base_id
184: FROM IGF_AP_FA_BASE_REC_ALL
185: WHERE person_id = p_person_id