Extract not picking employee termination date

Summary:

Employee terminated and rehired as Contingent worker the next day. Extract picking up his details but missing out termination date. Updated filter condition and added a condition as well. But still it was filtering out the termination date.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

(

(
asg.assignment_type IN ('E','C')
AND asg.effective_latest_change = 'Y'
AND asg.primary_flag = 'Y'
AND pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE')BETWEEN asg.effective_start_date AND asg.effective_end_date