Claim WebADI Download(Mapping) -Based on the Claim Status Parameters entered (Multiple seperated by

Hi ,

When user enters the Claim Status Multiple seperated by comma, it should download all the entered Status Claims.

I have taken the sql query and need help in finishing it.

If 'ALL' entered it should download all status Claims ,or if it is entered seperated by comma (as above) ,it should download all entered status Claims

query:

AND nvl(upper(p_claim_status) ,'ALL') like DECODE ($param$.p_claim_status,'ALL',nvl(upper(p_claim_status) ,'ALL'),upper($param$.p_claim_status)

OR ','||upper($param$.p_claim_status) || ',' LIKE '%,'||p_claim_status || ',%'