Confirm Start Date for Pending workers created outside ORC

Hello,

We have been using a task in the Enterprise Onboarding which asks to confirm your Hire Date. We have been using a configurable form with a custom SQL that fetches the Hire Date through the recruiting:

"SELECT TO_CHAR(PAAM.PROJECTED_START_DATE, 'MM/DD/YYYY')

FROM PER_ALLOCATED_CHECKLISTS PAC, PER_ALL_ASSIGNMENTS_M PAAM , IRC_OFFERS OFFER

WHERE PAAM.PERSON_ID = PAC.PERSON_ID

AND OFFER.PERSON_ID = PAC.PERSON_ID

AND PAAM.ASSIGNMENT_ID = OFFER.ASSIGNMENT_OFFER_ID

AND PAAM.EFFECTIVE_LATEST_CHANGE = 'Y'

AND PAAM.ASSIGNMENT_STATUS_TYPE = 'ACTIVE'

AND PAAM.ASSIGNMENT_TYPE = 'O'

AND PAC.ALLOCATION_DATE BETWEEN PAAM.EFFECTIVE_START_DATE AND PAAM.EFFECTIVE_END_DATE