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

Line 257: igf_aw_fund_cat fcat,

253: adisb.disb_net_amt
254: FROM igf_aw_award awd,
255: igf_aw_awd_disb adisb,
256: igf_aw_fund_mast fmast,
257: igf_aw_fund_cat fcat,
258: igf_ap_fa_base_rec fabase
259:
260: WHERE awd.award_id = p_award_id
261: AND adisb.award_id = awd.award_id

Line 477: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;

473: lv_acad_cal_type igs_ca_inst.cal_type%TYPE := NULL;
474: lv_acad_seq_number igs_ca_inst.sequence_number%TYPE := NULL ;
475: lv_message VARCHAR2(100) ;
476:
477: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
478: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
479: student_dtl_cur igf_sl_gen.person_dtl_cur;
480: parent_dtl_cur igf_sl_gen.person_dtl_cur;
481: student_dtl_rec igf_sl_gen.person_dtl_rec;

Line 478: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;

474: lv_acad_seq_number igs_ca_inst.sequence_number%TYPE := NULL ;
475: lv_message VARCHAR2(100) ;
476:
477: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
478: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
479: student_dtl_cur igf_sl_gen.person_dtl_cur;
480: parent_dtl_cur igf_sl_gen.person_dtl_cur;
481: student_dtl_rec igf_sl_gen.person_dtl_rec;
482: parent_dtl_rec igf_sl_gen.person_dtl_rec;

Line 489: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,

485:
486: CURSOR c_lor_details (
487: cp_cal_type igs_ca_inst.cal_type%TYPE,
488: cp_seq_number igs_ca_inst.sequence_number%TYPE,
489: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
490: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
491: cp_loan_status igf_sl_loans.loan_status%TYPE,
492: cp_active igf_sl_loans.active%TYPE,
493: cp_dl_loan_number igf_sl_loans.loan_number%TYPE

Line 490: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,

486: CURSOR c_lor_details (
487: cp_cal_type igs_ca_inst.cal_type%TYPE,
488: cp_seq_number igs_ca_inst.sequence_number%TYPE,
489: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
490: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
491: cp_loan_status igf_sl_loans.loan_status%TYPE,
492: cp_active igf_sl_loans.active%TYPE,
493: cp_dl_loan_number igf_sl_loans.loan_number%TYPE
494: ) IS

Line 527: igf_aw_fund_cat fcat,

523: igf_sl_loans loans,
524: igf_sl_lor lor,
525: igf_aw_award awd,
526: igf_aw_fund_mast fmast,
527: igf_aw_fund_cat fcat,
528: igf_ap_fa_base_rec fabase,
529: igf_ap_isir_matched isr
530: WHERE
531: fabase.ci_cal_type = cp_cal_type AND