APPS.IGF_GR_PELL dependencies on IGS_CA_INST_ALL

Line 170: PROCEDURE rfms_load_rec ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

166:
167:
168:
169:
170: PROCEDURE rfms_load_rec ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
171: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
172: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE)
173: IS
174:

Line 171: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

167:
168:
169:
170: PROCEDURE rfms_load_rec ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
171: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
172: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE)
173: IS
174:
175: --

Line 221: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

217: ------------------------------------------------------------------------------
218: --
219:
220: CURSOR c_award ( x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
221: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
222: p_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)
223: IS
224: SELECT awd.base_id,
225: awd.award_id,

Line 222: p_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)

218: --
219:
220: CURSOR c_award ( x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
221: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
222: p_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)
223: IS
224: SELECT awd.base_id,
225: awd.award_id,
226: awd.offered_amt,

Line 375: CURSOR c_get_rep_entity_id(cp_cal_type igs_ca_inst_all.cal_type%TYPE,

371: gap.rcampus_id = rep.rcampus_id;
372:
373: l_coa_pell igf_ap_fa_base_rec_all.coa_pell%TYPE;
374:
375: CURSOR c_get_rep_entity_id(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
376: cp_seq_num igs_ca_inst_all.sequence_number%TYPE,
377: cp_atd_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE) IS
378: SELECT rep.rep_entity_id_txt
379: FROM igf_gr_attend_pell att,

Line 376: cp_seq_num igs_ca_inst_all.sequence_number%TYPE,

372:
373: l_coa_pell igf_ap_fa_base_rec_all.coa_pell%TYPE;
374:
375: CURSOR c_get_rep_entity_id(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
376: cp_seq_num igs_ca_inst_all.sequence_number%TYPE,
377: cp_atd_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE) IS
378: SELECT rep.rep_entity_id_txt
379: FROM igf_gr_attend_pell att,
380: igf_gr_report_pell rep

Line 978: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;

974: -- isir is not same as the payment isir.
975: ------------------------------------------------------------------------------
976: --
977:
978: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
979: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
980:
981:
982: BEGIN

Line 979: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

975: ------------------------------------------------------------------------------
976: --
977:
978: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
979: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
980:
981:
982: BEGIN
983: