APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_AW_AWARD_ALL

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