APPS.IGF_SL_DL_ORIG dependencies on IGF_AW_AWARD

Line 135: lv_orig_award_id igf_aw_award.award_id%TYPE;

131:
132: lv_data_record VARCHAR2(4000);
133: lv_data_header_record VARCHAR2(4000);
134:
135: lv_orig_award_id igf_aw_award.award_id%TYPE;
136: lv_orig_loan_id igf_sl_loans.loan_id%TYPE;
137: lv_orig_loan_num igf_sl_loans.loan_number%TYPE;
138: lv_num_of_rec NUMBER := 0;
139: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE := NULL;

Line 181: igf_aw_award awd,

177: fabase.base_id
178: FROM
179: igf_sl_loans loans,
180: igf_sl_lor lor,
181: igf_aw_award awd,
182: igf_aw_fund_mast fmast,
183: igf_aw_fund_cat fcat,
184: igf_ap_fa_base_rec fabase,
185: igf_ap_isir_matched isr

Line 213: igf_aw_award_all awd,

209:
210: CURSOR c_loans IS
211: SELECT loan.loan_id
212: FROM igf_sl_loans_all loan,
213: igf_aw_award_all awd,
214: igf_aw_fund_mast_all fmast,
215: igf_aw_fund_cat_all fcat
216: WHERE
217: loan.award_id = awd.award_id AND

Line 587: igf_aw_award_all awd,

583: lor.acad_begin_date,
584: lor.acad_end_date
585: FROM igf_sl_loans_all loans,
586: igf_sl_lor_all lor,
587: igf_aw_award_all awd,
588: igf_ap_fa_base_rec_all fabase,
589: igf_aw_fund_mast_all fmast
590: WHERE loans.loan_id = lv_orig_loan_id
591: AND loans.loan_id = lor.loan_id