BIP Report Error with XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Summary

As soon as report is submitted it throws XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Code Snippet

WITH
    tax_cal_dates
AS
   (SELECT
       (SELECT
             MIN(glp.START_DATE)
        FROM
            GL_PERIODS   glp
        WHERE
            glp.PERIOD_SET_NAME = 'VH Calendar' AND
            glp.PERIOD_NAME = nvl(:p_period_acct_start,glp.period_name))   min_date,
       (SELECT