APPS.IGF_SL_DL_VALIDATION dependencies on IGF_AW_FUND_CAT

Line 236: p_fund_type IN igf_aw_fund_cat.fed_fund_code%TYPE,

232: END get_system_grade_level;
233:
234: PROCEDURE loan_limit_validation (
235: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
236: p_fund_type IN igf_aw_fund_cat.fed_fund_code%TYPE,
237: p_award_id IN igf_aw_award_all.award_id%TYPE,
238: p_msg_name OUT NOCOPY fnd_new_messages.message_name%TYPE
239: )
240: IS

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 382: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,

378: -- FA 122 Loan Enhancements changed the cursor to obsolete the view igf_sl_lor_dtls_v
379: CURSOR cur_loans(
380: cp_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
381: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
382: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
383: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
384: cp_status_1 igf_sl_loans.loan_status%TYPE,
385: cp_status_2 igf_sl_loans.loan_status%TYPE,
386: cp_status_3 igf_sl_loans.loan_status%TYPE,

Line 383: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,

379: CURSOR cur_loans(
380: cp_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
381: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
382: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
383: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
384: cp_status_1 igf_sl_loans.loan_status%TYPE,
385: cp_status_2 igf_sl_loans.loan_status%TYPE,
386: cp_status_3 igf_sl_loans.loan_status%TYPE,
387: cp_loan_number igf_sl_loans.loan_number%TYPE,

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