DBA Data[Home] [Help]

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on HR_QUESTIONNAIRES

Line 2400: ,hr_questionnaires hq

2396: WHERE EXISTS
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'

Line 2433: ,hr_questionnaires hq

2429: SELECT hr_general.decode_person_name (person_id) person
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'

Line 2469: ,hr_questionnaires hq

2465: (
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