ORC Not able to get Submission_id in Fast formula
Summary: Not able to get Submission_id in Fast formula
Content (required): /*****************************************************************************
FORMULA NAME: XX_PREDAYONE_EMAIL_REMINDER
FORMULA TYPE: Recruiting Candidate Selection Process -- FF to trigger pre-day1 email within 2 weeks of start date Recruiting Candidate Selection Process
Author: AKumar
Date: 09-Aug-2022
*******************************************************************************/
INPUTS ARE DATA_ELEMENTS (TEXT_TEXT)
CONDITION_RESULT = 'N'
SUBID = IRC_SUBMISSION_ID IRC_CANDIDATE_LEGISLATIVE_INFORMATION_SUBMISSION_ID
l_status = add_rlog (-1 , -1 , 'Enter into AKUMAR FF ' )
/* HIRE_DT = GET_VALUE_SET('XXCHEN_PREDAYONE_EMAIL_REMINDER_VS','|=P_SUBMISSIONID=''||SUBID||''') */
SEND_FLAG = GET_VALUE_SET('XXCHEN_PREDAYONE_EMAIL_REMINDER_VS','|=P_SUBMISSIONID=''||(SUBID)||''')