Restrict Recruiters from Rehiring Ex-Employees When "Rehire Recommended" = No

Summary:

We have a business requirement to prevent recruiters from hiring former employees if the Rehire Recommended flag was marked as No during termination on the Work Relationship page.

We have created the following Fast Formula and are using it as a condition:

FF : CONDITION_RETURN = 'Y'

L_SUBMISSION_ID = GET_CONTEXT(SUBMISSION_ID,0)
PARM = '|=SUB_ID='||TO_CHAR(L_SUBMISSION_ID)

Rehire_Flag = GET_VALUE_SET('Candidate Rehire Recommendation Flag',PARM)

IF Rehire_Flag = 'N' THEN
(
CONDITION_RETURN = 'N'
)

RETURN CONDITION_RETURN

Value Set : select
PPOS.REHIRE_RECOMMENDATION

FROM
IRC_CANDIDATES IC
,IRC_SUBMISSIONS ISUB
,PER_ALL_PEOPLE_F PAPF