APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_AW_AWARD

Line 402: FROM igf_aw_award_all awd,

398: awd.offered_amt,
399: awd.accepted_amt,
400: fcat.fed_fund_code,
401: fcat.fund_code
402: FROM igf_aw_award_all awd,
403: igf_aw_fund_mast_all fmast,
404: igf_aw_fund_cat_all fcat
405: WHERE awd.base_id = cp_base_id AND
406: awd.award_number_txt = cp_award_number AND

Line 3311: l_award_id igf_aw_award_all.award_id%TYPE;

3307: p_loan_number VARCHAR2)
3308: IS
3309:
3310:
3311: l_award_id igf_aw_award_all.award_id%TYPE;
3312:
3313: l_lor_orig_id NUMBER;
3314: l_resp_r1_clrp1_id NUMBER;
3315:

Line 3612: CURSOR c_get_base_id ( cp_award_id igf_aw_award.award_id%TYPE)

3608: ln_albw_id igf_sl_alt_borw_all.albw_id%TYPE;
3609: ln_origination_id igf_sl_lor_all.origination_id%TYPE;
3610:
3611: -- FA 122 Loans Enhancements
3612: CURSOR c_get_base_id ( cp_award_id igf_aw_award.award_id%TYPE)
3613: IS
3614: SELECT base_id,
3615: ci_cal_type,
3616: ci_sequence_number

Line 3617: FROM igf_aw_award_v

3613: IS
3614: SELECT base_id,
3615: ci_cal_type,
3616: ci_sequence_number
3617: FROM igf_aw_award_v
3618: WHERE award_id = cp_award_id;
3619:
3620: l_get_base_id c_get_base_id%ROWTYPE;
3621: -- cursor to get the est_orig_fee_perct for the given set up FA 122 Loans Enhancemtns

Line 3653: igf_aw_award awd,

3649: lor.recipient_type,
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

Line 5086: l_award_id igf_aw_award_all.award_id%TYPE;

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;
5090: