SR 3-8639346291 : SQL id 2xzwjprnn80x3 consuming more than 50% CPU

Hi All,

The query belong to work bench payments, As per our observation we found in awr report, this query is consume more cpu of db servers.

Here below is the query

select v.invoice_num,v.invoice_id,v.invoice_type, v.pay_alone, v.exclusive_payment_flag, v.payment_num, v.amount_remaining,to_char(v.amount_remaining,fnd_currency.get_format_mask(v.currency_code,42)) char_amount_remaining,ap_payment_schedules_pkg.get_discount_available(v.invoice_id, v.payment_num,:1,:2) discount_available,to_char(ap_payment_schedules_pkg.get_discount_available(v.invoice_id,v.payment_num,