Table Value Set not returning data using pay_ff_functions.gvs

Summary:

Table Value Set not returning data while testing it using pay_ff_functions.gvs

Content (required):

I have created a value set of type Table using the following code:

Value Set Code : XX_PAY_GET_ELEMENT_DATE

Module : Global Human Resources

*FROM Clause : pay_run_results prr,pay_run_result_values prrv,pay_element_types_f petf,pay_payroll_assignments ppasg,pay_payroll_actions ppa,pay_payroll_rel_actions ppra,pay_requests pr,pay_flow_instances pfi

*Value Column Name: TO_CHAR(PPA.DATE_EARNED,'DD-MM-YYYY')

Value Column Type (defaulted) : VARCHAR2

where Clause:  ppra.payroll_rel_action_id   = prr.payroll_rel_action_id