Retreiving balance using pay_balance_pkg.get_value() for Regular Earnings in Canada legislation

Hi,

I am trying to get the value of Regular Earnings Year to Date balance for an employee in Canada legislation using the  pay_balance_pkg.get_value() function (in Date Mode).

But I am getting an error as shown below. Any idea what needs to be done to retrieve the balance?

select pay_balance_pkg.get_value( p_defined_balance_id =>11800,

                                                     p_assignment_id => 85858,

                                                     p_virtual_date => to_date('23-Jun-2019','DD-Mon-YYYY')

                                                    ) from dual;

Error

------

ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML

ORA-06512: at "APPS.PAY_CORE_UTILS", line 2616

ORA-06512: at "APPS.PAY_BALANCE_PKG", line 6251