DBA Data[Home] [Help]

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on HR_QUEST_ANSWERS

Line 2416: FROM hr_quest_answers hqa

2412: ,'N') = 'Y'
2413: AND NOT EXISTS
2414: (
2415: SELECT hqav.field_id
2416: FROM hr_quest_answers hqa
2417: ,hr_quest_answer_values hqav
2418: WHERE hqa.questionnaire_template_id = hq.questionnaire_template_id
2419: AND hqa.type = 'PARTICIPANT'
2420: AND hqa.type_object_id = pp.participant_id

Line 2449: FROM hr_quest_answers hqa

2445: ,'N') = 'Y'
2446: AND NOT EXISTS
2447: (
2448: SELECT hqav.field_id
2449: FROM hr_quest_answers hqa
2450: ,hr_quest_answer_values hqav
2451: WHERE hqa.questionnaire_template_id = hq.questionnaire_template_id
2452: AND hqa.type = 'PARTICIPANT'
2453: AND hqa.type_object_id = pp.participant_id

Line 2482: FROM hr_quest_answers hqa

2478: ,'N') = 'Y'
2479: AND NOT EXISTS
2480: (
2481: SELECT hqav.field_id
2482: FROM hr_quest_answers hqa
2483: ,hr_quest_answer_values hqav
2484: WHERE hqa.questionnaire_template_id = hq.questionnaire_template_id
2485: AND hqa.type = 'APPRAISAL'
2486: AND hqa.type_object_id = pa.appraisal_id