Passing multiple person numbers as input in HCM Extract

Summary:

To pass multiple person numbers as input in HCM Extract

Content (please ensure you mask any confidential information):

Trying to pass multiple person numbers as a input parameter from the extract run page and using the parameter value in extract where condition

Added new extract parameter Person_List of type text and passing multiple person numbers with comma separation and using below condition in extract condition

PPS.PERSON_ID IN ( SELECT P.PERSON_ID FROM PER_ALL_PEOPLE_F P WHERE P.PERSON_NUMBER IN
(SELECT REGEXP_SUBSTR(pay_report_utils.get_parameter_value_number('Person_List'), '[^,]+', 1, LEVEL) FROM DUAL