How to work with Multiple selection and NVL function In Parameter

Summary:

How to work with Multiple selection and NVL function

Content (required):

Hi All,

Hope everyone is doing well.

I have a below requirement for which i need you help

1)The report needs to filtered based on currency code

2)User should have the ability to select multiple currency code for report filtration

3)When user not entered any currency code the we need to pass 'USD' and 'STAT' as a currency code

SQL Query

I have used the below query for the above requirement

SELECT 'BURSTKEY' "KEY",

    GB.LEDGER_ID AS LEDGER,

    GCC.SEGMENT1 AS COMPANY,

    GCC.SEGMENT2 AS LOCATION,

    GCC.SEGMENT4 AS COST_CENTER,