APPS.HR_APPRAISALS_UTIL_SS dependencies on PER_PARTICIPANTS

Line 17: and exists (select * from per_participants pp where pp.PARTICIPATION_STATUS='COMPLETED'

13: and pce.rating_level_id = prl2.rating_level_id (+)
14: and pce.weighting_level_id = prl3.rating_level_id(+)
15: and (prl1.step_value is not null or prl2.step_value is not null or
16: prl3.step_value is not null)
17: and exists (select * from per_participants pp where pp.PARTICIPATION_STATUS='COMPLETED'
18: AND pp.PARTICIPATION_IN_COLUMN='APPRAISAL_ID'
19: AND pp.PARTICIPATION_IN_ID=(select APPRAISAL_ID from per_assessments
20: where assessment_id=p_assessment_id)
21: AND pp.PERSON_ID=pce.object_id );

Line 37: and exists (select * from per_participants pp where pp.PARTICIPATION_STATUS='COMPLETED'

33: and ppr.appraisal_id = pas.appraisal_id
34: and ppr.performance_level_id = prl.rating_level_id
35: and pos.appraisal_id = ppr.appraisal_id
36: and pos.objective_id = ppr.objective_id
37: and exists (select * from per_participants pp where pp.PARTICIPATION_STATUS='COMPLETED'
38: AND pp.PARTICIPATION_IN_COLUMN='APPRAISAL_ID'
39: AND pp.PARTICIPATION_IN_ID=(select APPRAISAL_ID from per_assessments
40: where assessment_id=p_assessment_id)
41: AND pp.PERSON_ID=ppr.PERSON_ID);