DBA Data[Home] [Help]

APPS.IGF_SP_GEN_001 dependencies on IGS_FI_INVLN_INT_ALL

Line 119: igs_fi_invln_int_all invln,

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