APPS.IGF_GR_PELL dependencies on IGF_AP_FA_BASE_REC_ALL

Line 172: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE)

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: --
176: ------------------------------------------------------------------------------

Line 220: CURSOR c_award ( x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

216: -- isir is not same as the payment isir.
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,

Line 355: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

351: l_payment_isir igf_ap_fa_base_rec.payment_isir_id%TYPE;
352:
353: -- Get coa
354: CURSOR c_coa_pell(
355: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
356: ) IS
357: SELECT coa_pell
358: FROM igf_ap_fa_base_rec_all
359: WHERE base_id = cp_base_id;

Line 358: FROM igf_ap_fa_base_rec_all

354: CURSOR c_coa_pell(
355: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
356: ) IS
357: SELECT coa_pell
358: FROM igf_ap_fa_base_rec_all
359: WHERE base_id = cp_base_id;
360:
361: CURSOR c_get_rep_pell_id(cp_cal_type VARCHAR2,cp_seq_num NUMBER,cp_att_pell_id VARCHAR2)
362: IS

Line 373: l_coa_pell igf_ap_fa_base_rec_all.coa_pell%TYPE;

369: gap.ci_sequence_number = cp_seq_num AND
370: gap.attending_pell_cd = cp_att_pell_id AND
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

Line 952: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

948:
949: PROCEDURE rfms_load( errbuf OUT NOCOPY VARCHAR,
950: retcode OUT NOCOPY NUMBER,
951: l_award_year IN VARCHAR2,
952: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
953: p_org_id IN NUMBER )
954: IS
955:
956: --

Line 1121: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

1117: CURSOR c_base_id(cp_award_id igf_aw_award_all.award_id%TYPE) IS
1118: SELECT base_id
1119: FROM igf_aw_award_all
1120: WHERE award_id = cp_award_id;
1121: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
1122:
1123: p_start_dt DATE;
1124: l_start_dt DATE;
1125: l_end_dt DATE;