APPS.IGF_GR_PELL dependencies on IGF_AP_FA_BASE_REC

Line 136: CURSOR c_fa_base ( x_base_id igf_ap_fa_base_rec.base_id%TYPE)

132: --
133: -- Cursor to Pick up Person Details
134: --
135:
136: CURSOR c_fa_base ( x_base_id igf_ap_fa_base_rec.base_id%TYPE)
137: IS
138: SELECT
139: faconv.base_id,
140: faconv.person_id,

Line 154: igf_ap_fa_base_rec faconv,

150: isir.secondary_efc,
151: isir.sec_efc_type,
152: isir.isir_id
153: FROM
154: igf_ap_fa_base_rec faconv,
155: igf_ap_isir_matched isir
156: WHERE
157: x_base_id = faconv.base_id AND
158: faconv.base_id = isir.base_id AND

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 351: l_payment_isir igf_ap_fa_base_rec.payment_isir_id%TYPE;

347: WHERE origination_id = c_orig_id;
348:
349: chk_ssn VARCHAR2(1);
350:
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

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 1034: CURSOR c_isir ( x_base_id igf_ap_fa_base_rec.base_id%TYPE)

1030: -- pell cycle year using function
1031: -- igf_gr_gen.get_cycle_year
1032: ------------------------------------------------------------------------
1033:
1034: CURSOR c_isir ( x_base_id igf_ap_fa_base_rec.base_id%TYPE)
1035: IS
1036: SELECT
1037: isir.original_ssn,
1038: isir.orig_name_id

Line 1047: CURSOR c_cal ( x_base_id igf_ap_fa_base_rec.base_id%TYPE)

1043:
1044: l_isir c_isir%rowtype;
1045:
1046:
1047: CURSOR c_cal ( x_base_id igf_ap_fa_base_rec.base_id%TYPE)
1048: IS
1049: SELECT
1050: ci_cal_type,ci_sequence_number
1051: FROM

Line 1052: igf_ap_fa_base_rec fabase

1048: IS
1049: SELECT
1050: ci_cal_type,ci_sequence_number
1051: FROM
1052: igf_ap_fa_base_rec fabase
1053: WHERE
1054: fabase.base_id = x_base_id;
1055:
1056: l_cal c_cal%rowtype;

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;