APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_AP_FA_BASE_REC

Line 3654: igf_ap_fa_base_rec fabase

3650: fabase.person_id student_id
3651: FROM igf_sl_loans loans,
3652: igf_sl_lor_v lor,
3653: igf_aw_award awd,
3654: igf_ap_fa_base_rec fabase
3655: WHERE fabase.base_id = awd.base_id
3656: AND loans.award_id = awd.award_id
3657: AND loans.loan_id = lor.loan_id
3658: AND loans.loan_id = p_loan_id;

Line 3672: FROM igf_ap_fa_base_rec fabase,

3668:
3669: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
3670: IS
3671: SELECT isir.dependency_status
3672: FROM igf_ap_fa_base_rec fabase,
3673: igf_ap_isir_matched isir
3674: WHERE isir.payment_isir = 'Y'
3675: AND isir.system_record_type = 'ORIGINAL'
3676: AND isir.base_id = fabase.base_id

Line 5084: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;

5080: l_batch_desc VARCHAR2(80);
5081: l_chk_profile VARCHAR2(1);
5082: l_chk_batch VARCHAR2(1);
5083:
5084: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
5085: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
5086: l_award_id igf_aw_award_all.award_id%TYPE;
5087: l_fed_fund_cd igf_aw_fund_cat.fed_fund_code%TYPE;
5088: lv_person_id igs_pe_hz_parties.party_id%TYPE;

Line 5085: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

5081: l_chk_profile VARCHAR2(1);
5082: l_chk_batch VARCHAR2(1);
5083:
5084: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
5085: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
5086: l_award_id igf_aw_award_all.award_id%TYPE;
5087: l_fed_fund_cd igf_aw_fund_cat.fed_fund_code%TYPE;
5088: lv_person_id igs_pe_hz_parties.party_id%TYPE;
5089: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

Line 5089: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

5085: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
5086: l_award_id igf_aw_award_all.award_id%TYPE;
5087: l_fed_fund_cd igf_aw_fund_cat.fed_fund_code%TYPE;
5088: lv_person_id igs_pe_hz_parties.party_id%TYPE;
5089: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
5090:
5091: l_interface c_interface%ROWTYPE;
5092: l_disb_interface c_disb_interface%ROWTYPE;
5093: