APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_AW_FUND_CAT_ALL

Line 34: fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,

30: cal_type igs_ca_inst_all.cal_type%TYPE,
31: sequence_number igs_ca_inst_all.sequence_number%TYPE,
32: fund_id igf_aw_fund_mast_all.fund_id%TYPE,
33: discontinue_fund igf_aw_fund_mast_all.discontinue_fund%TYPE,
34: fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
35: base_id igf_ap_fa_base_rec_all.base_id%TYPE,
36: award_id igf_aw_award_all.award_id%TYPE,
37: loan_id igf_sl_loans_all.loan_id%TYPE,
38: loan_number igf_sl_loans_all.loan_number%TYPE,

Line 1042: ,igf_aw_fund_cat_all fcat

1038: FROM igf_sl_lor_all lor
1039: ,igf_sl_loans loans
1040: ,igf_aw_award_all awd
1041: ,igf_aw_fund_mast_all fmast
1042: ,igf_aw_fund_cat_all fcat
1043: ,igf_sl_cl_setup_all clset
1044: WHERE ((lor.loan_id = cp_n_loan_id) OR cp_n_loan_id IS NULL)
1045: AND loans.loan_id = lor.loan_id
1046: AND awd.award_id = loans.award_id

Line 1532: ,igf_aw_fund_cat_all fcat

1528: FROM igf_sl_lor_all lor
1529: ,igf_sl_loans_all loans
1530: ,igf_aw_award_all awd
1531: ,igf_aw_fund_mast_all fmast
1532: ,igf_aw_fund_cat_all fcat
1533: ,igf_sl_cl_recipient recip
1534: ,igf_ap_fa_base_rec_all fabase
1535: WHERE lor.relationship_cd = cp_v_relationship_cd
1536: AND ((lor.loan_id = cp_n_loan_id) OR cp_n_loan_id IS NULL)

Line 1693: l_v_loan_type igf_aw_fund_cat_all.fed_fund_code%TYPE;

1689:
1690: -- variables for (@1-07)
1691: l_v_chg_01_7_rec VARCHAR2(4000);
1692: l_c_01_07_flg VARCHAR2(1);
1693: l_v_loan_type igf_aw_fund_cat_all.fed_fund_code%TYPE;
1694: l_v_alt_prog_type_code igf_sl_lor_all.alt_prog_type_code%TYPE;
1695: c_student_dtls igf_sl_gen.person_dtl_cur;
1696: rec_student_dtls igf_sl_gen.person_dtl_rec;
1697: l_d_revised_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;