DBA Data[Home] [Help]

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_PARTICIPANTS

Line 2402: ,per_participants pp

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
2406: AND pp.participation_type = 'MAINAP'

Line 2435: ,per_participants pp

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
2439: AND pp.participation_type <> 'MAINAP'