DBA Data[Home] [Help]

APPS.HR_APPRAISALS_UTIL_SS dependencies on PER_PERFORMANCE_RATINGS

Line 29: from per_performance_ratings ppr, per_rating_levels_vl prl, per_assessments pas,

25: -- Global cursor for getting objective ratings
26: CURSOR get_objective_ratings(p_objective_id NUMBER,
27: p_assessment_id NUMBER) IS
28: select prl.step_value perf_value, pos.weighting_percent weigh_percent
29: from per_performance_ratings ppr, per_rating_levels_vl prl, per_assessments pas,
30: per_objectives pos
31: where pas.assessment_id = p_assessment_id
32: and ppr.objective_id = p_objective_id
33: and ppr.appraisal_id = pas.appraisal_id