DBA Data[Home] [Help]

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on HR_QUEST_ANSWER_VALUES

Line 2417: ,hr_quest_answer_values hqav

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
2421: AND hqa.questionnaire_answer_id = hqav.questionnaire_answer_id

Line 2450: ,hr_quest_answer_values hqav

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
2454: AND hqa.questionnaire_answer_id = hqav.questionnaire_answer_id

Line 2483: ,hr_quest_answer_values hqav

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
2487: AND hqa.questionnaire_answer_id = hqav.questionnaire_answer_id