Recruiting CSP fast formula to get hiring manager
Summary:
I am trying to create a fast formula to get hiring manager to use it to prevent hiring manager to move candidates on certain phases but it is doesn't stop the hiring manager
DEFAULT FOR IRC_CSP_REQ_NUMBER IS '0'
CONDITION_RESULT = 'Y'
L_REQUISITION_NUMBER=IRC_CSP_REQ_NUMBER
L_person_id = get_value_set('XX_GET_PERSON_ID')
L_manager_id= get_value_set('XX_REQUISITION_HIRING_MANAGER', '|=P_REQUISITION_NUMBER=' || L_REQUISITION_NUMBER)
IF (L_person_id = L_manager_id) THEN(
CONDITION_RESULT = 'N'
CONDITION_MESSAGE = 'N'
)
Content (please ensure you mask any confidential information):