APPS.HR_APPRAISALS_UTIL_SS dependencies on PER_OBJECTIVES

Line 25: per_objectives pos

21: CURSOR get_objective_ratings(p_objective_id NUMBER,
22: p_assessment_id NUMBER) IS
23: select prl.step_value perf_value, pos.weighting_percent weigh_percent
24: from per_performance_ratings ppr, per_rating_levels_vl prl, per_assessments pas,
25: per_objectives pos
26: where pas.assessment_id = p_assessment_id
27: and ppr.objective_id = p_objective_id
28: and ppr.appraisal_id = pas.appraisal_id
29: and ppr.performance_level_id = prl.rating_level_id

Line 497: from per_objectives po,

493: where pce.assessment_id = p_assessment_id and pce.type='ASSESSMENT'
494: and pce.object_name = 'ASSESSOR_ID';
495: cursor get_objectives is
496: select po.objective_id
497: from per_objectives po,
498: per_assessments pa
499: where pa.assessment_id = p_assessment_id
500: and po.appraisal_id = pa.appraisal_id;
501: cursor get_asmnt_type is