How to get questionnaire response from external candidates using BIP? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get questionnaire response from external candidates using BIP?

in Recruiting, Opportunity Marketplace

Hi Team,

I am not able to add questionnaire response in below query.

Could anyone please help me?

SELECT
distinct paam.person_id
--,pd.name
,to_char(paam.person_id) PERSON_NUMBER
,PPNF.DISPLAY_NAME EMPLOYEE_NAME
,PEA.EMAIL_ADDRESS PERSONAL_EMAIL
,(SELECT PPNF_MGR.DISPLAY_NAME
FROM PER_ASSIGNMENT_SUPERVISORS_F PASF
,PER_PERSON_NAMES_F PPNF_MGR
,PER_ALL_PEOPLE_F PAPF_MGR
WHERE TRUNC(NVL(PPOS.ACTUAL_TERMINATION_DATE,TRUNC(PPOS.DATE_START))) BETWEEN PASF.EFFECTIVE_START_DATE AND PASF.EFFECTIVE_END_DATE
AND PASF.MANAGER_TYPE = 'LINE_MANAGER'
AND PASF.MANAGER_ID = PPNF_MGR.PERSON_ID

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!