APPS.IGF_SP_GEN_001 dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 43: p_n_unit_ver_num IN igs_ps_unit_ofr_opt_all.version_number%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,
45: x_new_spnsp_amount OUT NOCOPY NUMBER
46: ) AS
47: -----------------------------------------------------------------------------------

Line 121: igs_ps_unit_ofr_opt_all uoo

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
125: AND inv.transaction_type <> 'RETENTION'