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_SP_GEN_001 dependencies on IGF_AW_FUND_CAT_ALL

Line 37: p_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE,

33: PROCEDURE get_sponsor_amts (
34: p_n_person_id IN hz_parties.party_id%TYPE,
35: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
36: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
37: p_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE,
38: p_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
39: p_n_ld_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
40: p_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
41: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,

Line 168: cp_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE)

164: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
165: cp_n_fee_seq_number IN igs_ca_inst.sequence_number%TYPE,
166: cp_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
167: cp_n_ld_seq_number IN igs_ca_inst.sequence_number%TYPE,
168: cp_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE)
169: IS
170: SELECT appl.amount_applied AS amount_applied, appl.credit_id as credit_id
171: FROM igs_fi_applications appl,
172: igs_fi_credits_all crd,