How to include non workers into HCM Extract
Summary:
Hello,
we need to add non workers in HCM extract.
I tried to add the following filters
((((asg.assignment_type IN ('N')) AND (asg.primary_assignment_flag='Y'))
)
AND ((pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE') BETWEEN asg.effective_start_date AND asg.effective_end_date)
OR ((asg.effective_start_date>pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE'))
AND (asg.action_code IN ('HIRE', 'ADD_CWK', 'REHIRE','ADD_NON_WKR'))
)
)
)
OR
((asg.assignment_type = ('N')
)
AND ((pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE') BETWEEN asg.effective_start_date AND asg.effective_end_date)