Display the completion date of the line manager feedback on the candidate who is selected/ hired
Summary:
Hi Everyone,
I'm facing roadblock in building query to show completion date of the line manager feedback only for the candidate who is selected/ hired
Query I wrote is giving all manager evaluations. I don't see any column in IRC_IM_FEEDBK_REQUESTS table that can be used to join with other table having candidate info like IRC_SUBMISSIONS, IRC_OFFERS, IRC_CANDIDATES.
Can you please help me to achieve requirement of displaying only completion date of the line manager feedback on the candidate who is selected/ hired.
Thank you.
Regards,
Hrushikesh Pentewad.
Content (please ensure you mask any confidential information):