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

Line 144: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;

140: l_driver_license_state igf_ap_isir_matched.driver_license_state%TYPE;
141: l_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
142: l_alien_reg_number igf_ap_isir_matched.alien_reg_number%TYPE;
143: l_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
144: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
145: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
146: student_dtl_cur igf_sl_gen.person_dtl_cur;
147: parent_dtl_cur igf_sl_gen.person_dtl_cur;
148: student_dtl_rec igf_sl_gen.person_dtl_rec;

Line 145: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;

141: l_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
142: l_alien_reg_number igf_ap_isir_matched.alien_reg_number%TYPE;
143: l_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
144: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
145: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
146: student_dtl_cur igf_sl_gen.person_dtl_cur;
147: parent_dtl_cur igf_sl_gen.person_dtl_cur;
148: student_dtl_rec igf_sl_gen.person_dtl_rec;
149: parent_dtl_rec igf_sl_gen.person_dtl_rec;

Line 158: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,

154: -- FA 122 Loans Enhancemnts changed the cursor to remove the obsolete view igf_sl_lor_dtls_v
155: CURSOR c_lor(
156: p_cal_type igs_ca_inst.cal_type%TYPE,
157: p_seq_num igs_ca_inst.sequence_number%TYPE,
158: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
159: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
160: p_loan_status igf_sl_loans.loan_status%TYPE,
161: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE,
162: p_active igf_sl_loans.active%TYPE

Line 159: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,

155: CURSOR c_lor(
156: p_cal_type igs_ca_inst.cal_type%TYPE,
157: p_seq_num igs_ca_inst.sequence_number%TYPE,
158: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
159: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
160: p_loan_status igf_sl_loans.loan_status%TYPE,
161: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE,
162: p_active igf_sl_loans.active%TYPE
163: ) IS

Line 192: igf_aw_fund_cat fcat,

188: igf_sl_loans loans,
189: igf_sl_lor lor,
190: igf_aw_award awd,
191: igf_aw_fund_mast fmast,
192: igf_aw_fund_cat fcat,
193: igf_ap_fa_base_rec fabase
194: WHERE
195: fabase.ci_cal_type = p_cal_type AND
196: fabase.ci_sequence_number = p_seq_num AND