passing multiple values for a single parameter in oracle apps Reports

passing multiple values for a single parameter in oracle apps Reports:

Here Comma delimited Multiple values parameter considering as a single sting .

Example : If passing parameter value as 'ABC,ABCD' This entire sting consider as a single string but i want to use this as a comma delimited like in ('ABC','ABCD')

By using below Example it could be Rectified.


 SELECT * FROM XX_TABLE WHERE XX_COLUMN in (SELECT REGEXP_SUBSTR (value,'[^, ]+',1,LEVEL) value
        FROM (SELECT 'ABC,ABCD' value FROM dual)
                  connect BY REGEXP_SUBSTR (value,'[^, ]+',1,LEVEL) IS NOT NULL) --ABC,ABCD