eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HR_APPRAISALS_UTIL_SS dependencies on PER_ASSESSMENTS

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

20: -- Global cursor for getting objective ratings
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

Line 49: per_assessments pas

45: pap.appraisal_template_id,
46: pap.system_type,
47: pap.type
48: from per_appraisals pap,
49: per_assessments pas
50: where pas.assessment_id = p_assessment_id
51: and pap.appraisal_id = pas.appraisal_id;
52:
53: FUNCTION get_comp_line_score(p_line_formula IN VARCHAR,

Line 376: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments

372:
373: function get_competence_score (p_competence_id NUMBER,
374: p_assessment_id NUMBER) return NUMBER IS
375: cursor get_line_formula is
376: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments
377: where per_assessments.assessment_id = p_assessment_id
378: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
379:
380: l_num_part NUMBER := 0;

Line 377: where per_assessments.assessment_id = p_assessment_id

373: function get_competence_score (p_competence_id NUMBER,
374: p_assessment_id NUMBER) return NUMBER IS
375: cursor get_line_formula is
376: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments
377: where per_assessments.assessment_id = p_assessment_id
378: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
379:
380: l_num_part NUMBER := 0;
381: l_line_formula per_assessment_types.line_score_formula%type;

Line 378: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;

374: p_assessment_id NUMBER) return NUMBER IS
375: cursor get_line_formula is
376: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments
377: where per_assessments.assessment_id = p_assessment_id
378: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
379:
380: l_num_part NUMBER := 0;
381: l_line_formula per_assessment_types.line_score_formula%type;
382: l_line_formula_id per_assessment_types.line_score_formula_id%type;

Line 434: per_assessments pas

430: select pat.line_score_formula,
431: pat.line_score_formula_id,
432: pas.assessment_id
433: from per_assessment_types pat,
434: per_assessments pas
435: where pas.appraisal_id = p_appraisal_id
436: and pas.assessment_type_id = pat.assessment_type_id
437: and pat.type = 'OBJECTIVE';
438:

Line 442: l_assessment_id per_assessments.assessment_id%type;

438:
439: l_num_part NUMBER := 0;
440: l_line_formula per_assessment_types.line_score_formula%type;
441: l_line_formula_id per_assessment_types.line_score_formula_id%type;
442: l_assessment_id per_assessments.assessment_id%type;
443: l_perf_value NUMBER;
444: l_tot_prof_value NUMBER default 0;
445: l_tot_perf_value NUMBER default 0;
446: l_tot_weigh_value NUMBER default 0;

Line 487: select total_score_formula from per_assessment_types, per_assessments

483: end get_objective_score;
484:
485: function get_assessment_score (p_assessment_id NUMBER) return NUMBER IS
486: cursor get_score_formula is
487: select total_score_formula from per_assessment_types, per_assessments
488: where per_assessments.assessment_id = p_assessment_id
489: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
490: cursor get_competences is
491: select distinct pce.competence_id

Line 488: where per_assessments.assessment_id = p_assessment_id

484:
485: function get_assessment_score (p_assessment_id NUMBER) return NUMBER IS
486: cursor get_score_formula is
487: select total_score_formula from per_assessment_types, per_assessments
488: where per_assessments.assessment_id = p_assessment_id
489: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
490: cursor get_competences is
491: select distinct pce.competence_id
492: from per_competence_elements pce

Line 489: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;

485: function get_assessment_score (p_assessment_id NUMBER) return NUMBER IS
486: cursor get_score_formula is
487: select total_score_formula from per_assessment_types, per_assessments
488: where per_assessments.assessment_id = p_assessment_id
489: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
490: cursor get_competences is
491: select distinct pce.competence_id
492: from per_competence_elements pce
493: where pce.assessment_id = p_assessment_id and pce.type='ASSESSMENT'

Line 498: per_assessments pa

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
502: select nvl(pst.type, 'COMPETENCE'),

Line 505: per_assessments pa

501: cursor get_asmnt_type is
502: select nvl(pst.type, 'COMPETENCE'),
503: pa.appraisal_id
504: from per_assessment_types pst,
505: per_assessments pa
506: where pa.assessment_id = p_assessment_id
507: and pst.assessment_type_id = pa.assessment_type_id;
508: l_num_part NUMBER := 0;
509: l_score_formula per_assessment_types.total_score_formula%type;

Line 566: per_assessments pa

562: cursor get_assessments is
563: select pa.assessment_id,
564: nvl(pst.type, 'COMPETENCE')
565: from per_assessment_types pst,
566: per_assessments pa
567: where pa.appraisal_id = p_appraisal_id
568: and pst.assessment_type_id = pa.assessment_type_id;
569: l_assessment_id per_assessments.assessment_id%type;
570: l_comp_asmt_score NUMBER;

Line 569: l_assessment_id per_assessments.assessment_id%type;

565: from per_assessment_types pst,
566: per_assessments pa
567: where pa.appraisal_id = p_appraisal_id
568: and pst.assessment_type_id = pa.assessment_type_id;
569: l_assessment_id per_assessments.assessment_id%type;
570: l_comp_asmt_score NUMBER;
571: l_obj_asmt_score NUMBER;
572: l_asmnt_type per_assessment_types.type%type;
573: begin