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.

APPS.HR_APPRAISALS_UTIL_SS dependencies on PER_ASSESSMENT_TYPES

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 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 381: l_line_formula per_assessment_types.line_score_formula%type;

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;
383: l_prof_value NUMBER;
384: l_perf_value NUMBER;
385: l_weigh_value NUMBER;

Line 382: l_line_formula_id per_assessment_types.line_score_formula_id%type;

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;
383: l_prof_value NUMBER;
384: l_perf_value NUMBER;
385: l_weigh_value NUMBER;
386: l_tot_prof_value NUMBER default 0;

Line 433: from per_assessment_types pat,

429: cursor get_line_formula is
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';

Line 440: l_line_formula per_assessment_types.line_score_formula%type;

436: and pas.assessment_type_id = pat.assessment_type_id
437: and pat.type = 'OBJECTIVE';
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;

Line 441: l_line_formula_id per_assessment_types.line_score_formula_id%type;

437: and pat.type = 'OBJECTIVE';
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;

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 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 504: from per_assessment_types pst,

500: and po.appraisal_id = pa.appraisal_id;
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;

Line 509: l_score_formula per_assessment_types.total_score_formula%type;

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;
510: l_total_score NUMBER := 0;
511: l_competence_id NUMBER;
512: l_objective_id NUMBER;
513: l_asmnt_type per_assessment_types.type%type;

Line 513: l_asmnt_type per_assessment_types.type%type;

509: l_score_formula per_assessment_types.total_score_formula%type;
510: l_total_score NUMBER := 0;
511: l_competence_id NUMBER;
512: l_objective_id NUMBER;
513: l_asmnt_type per_assessment_types.type%type;
514: l_appraisal_id per_appraisals.appraisal_id%type;
515: begin
516: open get_score_formula;
517: fetch get_score_formula into l_score_formula;

Line 565: from per_assessment_types pst,

561: p_final_formula_id NUMBER) return NUMBER IS
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;

Line 572: l_asmnt_type per_assessment_types.type%type;

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
574:
575: open get_assessments;
576: loop