How to get questionnaire response from external candidates using BIP?
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