How to pass a date from a HCM Fast Formula to a table validated valueset using GET_VALUE_SET

Summary

How to pass a date from a HCM Fast Formula to a table validated valueset using GET_VALUE_SET

Content

Hi,

I need to pass the effective date from a fast formula to a table validated value-set.

It is part of an extract rule. My valueset (table validated) has the following query.

Valueset query :

prgf.time_card_req  =
(
SELECT prgf1.time_card_req
FROM pay_rel_groups_dn    prgd
    ,pay_rel_groups_f    prgf1
WHERE
1 = 1
AND     prgd.assignment_id = TO_NUMBER(:{PARAMETER.P_ASSIGNMENT_ID})
AND     prgd.group_type    = 'A'
AND     prgd.relationship_group_id  = prgf1.relationship_group_id