DBA Data[Home] [Help]

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on HR_QUEST_FIELDS

Line 2401: ,hr_quest_fields hqf

2397: (
2398: SELECT 'x'
2399: FROM per_appraisals pa
2400: ,hr_questionnaires hq
2401: ,hr_quest_fields hqf
2402: ,per_participants pp
2403: WHERE pa.appraisal_id = c_appraisal_id
2404: AND pp.participation_in_table = 'PER_APPRAISALS'
2405: AND pp.participation_in_id = pa.appraisal_id

Line 2434: ,hr_quest_fields hqf

2430: FROM (
2431: SELECT DISTINCT(pp.person_id) person_id
2432: FROM per_appraisals pa
2433: ,hr_questionnaires hq
2434: ,hr_quest_fields hqf
2435: ,per_participants pp
2436: WHERE pa.appraisal_id = c_appraisal_id
2437: AND pp.participation_in_table = 'PER_APPRAISALS'
2438: AND pp.participation_in_id = pa.appraisal_id

Line 2470: ,hr_quest_fields hqf

2466: SELECT 'x'
2467: FROM per_appraisals pa
2468: ,per_appraisal_templates pat
2469: ,hr_questionnaires hq
2470: ,hr_quest_fields hqf
2471: WHERE pa.appraisal_id = c_appraisal_id
2472: AND pa.appraisal_template_id = pat.appraisal_template_id
2473: AND pat.questionnaire_template_id = hq.questionnaire_template_id
2474: AND nvl (hq.quest_type_code