eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_DL_ORIG dependencies on IGF_AW_FUND_CAT

Line 168: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,

164:
165: CURSOR cur_loan_details (
166: cp_cal_type igs_ca_inst.cal_type%TYPE,
167: cp_seq_number igs_ca_inst.sequence_number%TYPE,
168: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
169: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
170: cp_loan_status igf_sl_loans.loan_status%TYPE,
171: cp_active igf_sl_loans.active%TYPE,
172: cp_dl_loan_number igf_sl_loans.loan_number%TYPE

Line 169: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,

165: CURSOR cur_loan_details (
166: cp_cal_type igs_ca_inst.cal_type%TYPE,
167: cp_seq_number igs_ca_inst.sequence_number%TYPE,
168: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
169: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
170: cp_loan_status igf_sl_loans.loan_status%TYPE,
171: cp_active igf_sl_loans.active%TYPE,
172: cp_dl_loan_number igf_sl_loans.loan_number%TYPE
173: )

Line 183: igf_aw_fund_cat fcat,

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
186: WHERE
187: fabase.ci_cal_type = cp_cal_type AND

Line 206: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;

202: substr(loans.loan_number, 13, 6) = p_school_code;
203:
204: loan_details_rec cur_loan_details%ROWTYPE;
205:
206: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
207: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
208:
209:
210: CURSOR c_loans IS

Line 207: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;

203:
204: loan_details_rec cur_loan_details%ROWTYPE;
205:
206: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
207: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
208:
209:
210: CURSOR c_loans IS
211: SELECT loan.loan_id

Line 215: igf_aw_fund_cat_all fcat

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
218: awd.fund_id = fmast.fund_id AND
219: fcat.fund_code = fmast.fund_code AND