DBA Data[Home] [Help]

APPS.IGS_FI_GEN_008 dependencies on IGS_FI_INVLN_INT

Line 278: igs_fi_invln_int invln

274: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
275: cp_transaction_type igs_fi_inv_int_all.transaction_type%TYPE) IS
276: SELECT inv.invoice_number
277: FROM igs_fi_inv_int inv,
278: igs_fi_invln_int invln
279: WHERE inv.person_id=cp_person_id
280: AND invln.invoice_id=inv.invoice_id
281: AND inv.fee_cal_type=cp_fee_cal_type
282: AND (inv.fee_cat = cp_fee_cat OR (inv.fee_cat IS NULL AND cp_fee_cat IS NULL))