DBA Data[Home] [Help]

APPS.IGF_GR_GEN_XML dependencies on IGS_CA_INST_ALL

Line 180: CURSOR cur_get_base ( p_cal_type igs_ca_inst_all.cal_type%TYPE,

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

Line 181: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,

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