APPS.IGF_SL_DL_VALIDATION dependencies on IGF_AW_FUND_CAT_ALL

Line 348: l_fed_fund_1 igf_aw_fund_cat_all.fed_fund_code%TYPE;

344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;
347: l_status_3 igf_sl_loans_all.loan_status%TYPE;
348: l_fed_fund_1 igf_aw_fund_cat_all.fed_fund_code%TYPE;
349: l_fed_fund_2 igf_aw_fund_cat_all.fed_fund_code%TYPE;
350: student_dtl_cur igf_sl_gen.person_dtl_cur;
351: parent_dtl_cur igf_sl_gen.person_dtl_cur;
352: lv_message VARCHAR2(100);

Line 349: l_fed_fund_2 igf_aw_fund_cat_all.fed_fund_code%TYPE;

345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;
347: l_status_3 igf_sl_loans_all.loan_status%TYPE;
348: l_fed_fund_1 igf_aw_fund_cat_all.fed_fund_code%TYPE;
349: l_fed_fund_2 igf_aw_fund_cat_all.fed_fund_code%TYPE;
350: student_dtl_cur igf_sl_gen.person_dtl_cur;
351: parent_dtl_cur igf_sl_gen.person_dtl_cur;
352: lv_message VARCHAR2(100);
353: lv_complete BOOLEAN;

Line 358: lv_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;

354: lv_disb_count NUMBER;
355: lv_special_school VARCHAR2(30);
356: l_dl_std_code igf_ap_class_std_map.dl_std_code%TYPE;
357: lv_dummy varchar2(1);
358: lv_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
359: lv_msg_name fnd_new_messages.message_name%TYPE;
360: lv_lookup_code igf_lookups_view.lookup_code%TYPE;
361:
362: /***********************************************************************************

Line 414: igf_aw_fund_cat_all fcat,

410: igf_sl_loans_all loans,
411: igf_sl_lor_all lor,
412: igf_aw_award_all awd,
413: igf_aw_fund_mast_all fmast,
414: igf_aw_fund_cat_all fcat,
415: igf_ap_fa_base_rec_all fabase
416: WHERE fabase.ci_cal_type = cp_cal_type
417: AND fabase.ci_sequence_number = cp_seq_number
418: AND fabase.base_id = awd.base_id

Line 438: igf_aw_fund_cat_all fcat

434: SELECT fcat.fed_fund_code
435: FROM igf_sl_loans_all loans,
436: igf_aw_award_all awd,
437: igf_aw_fund_mast_all fmast,
438: igf_aw_fund_cat_all fcat
439: WHERE
440: loans.award_id = awd.award_id AND
441: awd.fund_id = fmast.fund_id AND
442: fmast.fund_code = fcat.fund_code AND