[Home] [Help]
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
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