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_CL_ORIG dependencies on IGF_AW_FUND_CAT

Line 206: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,

202:
203: -- To fetch the Loan Records based on the Recepient Information
204: CURSOR cur_loan_dtls(p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
205: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
206: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
207: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
208: p_loan_number igf_sl_loans.loan_number%TYPE,
209: p_loan_status igf_sl_loans.loan_status%TYPE,
210: p_active igf_sl_loans.active%TYPE,

Line 207: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,

203: -- To fetch the Loan Records based on the Recepient Information
204: CURSOR cur_loan_dtls(p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
205: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
206: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
207: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
208: p_loan_number igf_sl_loans.loan_number%TYPE,
209: p_loan_status igf_sl_loans.loan_status%TYPE,
210: p_active igf_sl_loans.active%TYPE,
211: p_relationship_cd igf_sl_lor_all.relationship_cd%TYPE,

Line 342: igf_aw_fund_cat_all fcat,

338: FROM igf_sl_loans_all loans,
339: igf_sl_lor_all lor,
340: igf_aw_award_all awd,
341: igf_aw_fund_mast_all fmast,
342: igf_aw_fund_cat_all fcat,
343: igf_ap_fa_base_rec_all fabase,
344: igf_sl_cl_recipient recip
345: WHERE fabase.ci_cal_type = p_cal_type
346: AND fabase.ci_sequence_number = p_seq_number

Line 429: igf_aw_fund_cat fcat,

425: igf_sl_loans lar,
426: igf_sl_lor lor,
427: igf_aw_award awd,
428: igf_aw_fund_mast fund,
429: igf_aw_fund_cat fcat,
430: igf_sl_cl_recipient recip
431: WHERE lar.loan_id = lor.loan_id
432: AND lar.award_id = awd.award_id
433: AND awd.base_id = fabase.base_id

Line 1261: lv_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;

1257: lv_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1258: lv_recip_non_ed_brc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1259: l_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
1260: l_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
1261: lv_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
1262: lv_eft_authorization igf_sl_cl_setup.eft_authorization%TYPE;
1263: l_dummy_pell_efc NUMBER;
1264:
1265: lv_source_name igf_lookups_view.meaning%TYPE;

Line 1305: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;

1301: l_s_ssn VARCHAR2(9);
1302: l_trailer_datetime VARCHAR2(14);
1303: ln_num_of_disb NUMBER;
1304: lv_indi VARCHAR2(1);
1305: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
1306: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
1307: lv_stud_sign_ind igf_sl_lor.stud_sign_ind%TYPE;
1308: lv_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;
1309: lv_borr_sign_ind igf_sl_lor.borr_sign_ind%TYPE;

Line 1306: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;

1302: l_trailer_datetime VARCHAR2(14);
1303: ln_num_of_disb NUMBER;
1304: lv_indi VARCHAR2(1);
1305: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
1306: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
1307: lv_stud_sign_ind igf_sl_lor.stud_sign_ind%TYPE;
1308: lv_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;
1309: lv_borr_sign_ind igf_sl_lor.borr_sign_ind%TYPE;
1310: lv_rel_code VARCHAR2(30);