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 IGS_FI_FEE_TYPE_ALL

Line 40: p_v_fee_class IN igs_fi_fee_type_all.fee_class%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,
42: p_v_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
43: p_n_unit_ver_num IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
44: x_eligible_amount OUT NOCOPY NUMBER,

Line 80: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE

76: CURSOR cur_get_charges_no_coursecd (
77: cp_n_person_id IN hz_parties.party_id%TYPE,
78: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
79: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
80: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE
81: ) IS
82: SELECT inv.invoice_id, inv.invoice_amount
83: FROM igs_fi_inv_int_all inv,
84: igs_fi_fee_type_all ft

Line 84: igs_fi_fee_type_all ft

80: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE
81: ) IS
82: SELECT inv.invoice_id, inv.invoice_amount
83: FROM igs_fi_inv_int_all inv,
84: igs_fi_fee_type_all ft
85: WHERE inv.person_id = cp_n_person_id
86: AND inv.fee_cal_type = cp_v_fee_cal_type
87: AND inv.fee_ci_sequence_number = cp_n_fee_seq_number
88: AND inv.transaction_type NOT IN ('RETENTION','REFUND','AID_ADJ','WAIVER_ADJ','SPONSOR','PAY_PLAN')

Line 95: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,

91:
92: CURSOR cur_get_charges_with_coursecd ( cp_n_person_id IN hz_parties.party_id%TYPE,
93: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
94: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
95: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
96: cp_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE
97: ) IS
98: SELECT inv.invoice_id, inv.invoice_amount
99: FROM igs_fi_inv_int_all inv,

Line 100: igs_fi_fee_type_all ft

96: cp_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE
97: ) IS
98: SELECT inv.invoice_id, inv.invoice_amount
99: FROM igs_fi_inv_int_all inv,
100: igs_fi_fee_type_all ft
101: WHERE inv.person_id = cp_n_person_id
102: AND inv.fee_cal_type = cp_v_fee_cal_type
103: AND inv.fee_ci_sequence_number = cp_n_fee_seq_number
104: AND inv.transaction_type <> 'RETENTION'

Line 113: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,

109: CURSOR cur_get_charges_for_unit (
110: cp_n_person_id IN hz_parties.party_id%TYPE,
111: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
112: cp_n_fee_seq_number IN igs_ca_inst.sequence_number%TYPE,
113: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
114: cp_v_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,
115: cp_n_unit_ver_num IN igs_ps_unit_ver_all.version_number%TYPE
116: ) IS
117: SELECT inv.invoice_id, inv.invoice_amount

Line 120: igs_fi_fee_type_all ft,

116: ) IS
117: SELECT inv.invoice_id, inv.invoice_amount
118: FROM igs_fi_inv_int_all inv,
119: igs_fi_invln_int_all invln,
120: igs_fi_fee_type_all ft,
121: igs_ps_unit_ofr_opt_all uoo
122: WHERE inv.person_id = cp_n_person_id
123: AND inv.fee_cal_type = cp_v_fee_cal_type
124: AND inv.fee_ci_sequence_number =cp_n_fee_seq_number