How to add response of questionnaire? — 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 add response of questionnaire?

in BI Publisher Learning Center

Hi team,

I want to add response of questionnaire for below query. Could anyone help me?

SELECT
distinct paam.person_id
,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
AND TRUNC(NVL(PPOS.ACTUAL_TERMINATION_DATE,TRUNC(PPOS.DATE_START))) BETWEEN PPNF_MGR.EFFECTIVE_START_DATE AND PPNF_MGR.EFFECTIVE_END_DATE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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