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_ASSESSMENTS

Line 19: AND pp.PARTICIPATION_IN_ID=(select APPRAISAL_ID from per_assessments

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 );
22: -- table type for appraisal objectives
23: TYPE comp_ratings_table IS TABLE OF get_competence_ratings%ROWTYPE INDEX BY BINARY_INTEGER ;

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

Line 39: AND pp.PARTICIPATION_IN_ID=(select APPRAISAL_ID from per_assessments

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);
42:
43: -- table type for appraisal objectives

Line 59: per_assessments pas

55: pap.appraisal_template_id,
56: pap.system_type,
57: pap.type
58: from per_appraisals pap,
59: per_assessments pas
60: where pas.assessment_id = p_assessment_id
61: and pap.appraisal_id = pas.appraisal_id;
62:
63: FUNCTION get_comp_line_score(p_line_formula IN VARCHAR,

Line 390: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments

386:
387: function get_competence_score (p_competence_id NUMBER,
388: p_assessment_id NUMBER) return NUMBER IS
389: cursor get_line_formula is
390: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments
391: where per_assessments.assessment_id = p_assessment_id
392: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
393:
394: l_num_part NUMBER := 0;

Line 391: where per_assessments.assessment_id = p_assessment_id

387: function get_competence_score (p_competence_id NUMBER,
388: p_assessment_id NUMBER) return NUMBER IS
389: cursor get_line_formula is
390: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments
391: where per_assessments.assessment_id = p_assessment_id
392: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
393:
394: l_num_part NUMBER := 0;
395: l_line_formula per_assessment_types.line_score_formula%type;

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

388: p_assessment_id NUMBER) return NUMBER IS
389: cursor get_line_formula is
390: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments
391: where per_assessments.assessment_id = p_assessment_id
392: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
393:
394: l_num_part NUMBER := 0;
395: l_line_formula per_assessment_types.line_score_formula%type;
396: l_line_formula_id per_assessment_types.line_score_formula_id%type;

Line 448: per_assessments pas

444: select pat.line_score_formula,
445: pat.line_score_formula_id,
446: pas.assessment_id
447: from per_assessment_types pat,
448: per_assessments pas
449: where pas.appraisal_id = p_appraisal_id
450: and pas.assessment_type_id = pat.assessment_type_id
451: and pat.type = 'OBJECTIVE';
452:

Line 456: l_assessment_id per_assessments.assessment_id%type;

452:
453: l_num_part NUMBER := 0;
454: l_line_formula per_assessment_types.line_score_formula%type;
455: l_line_formula_id per_assessment_types.line_score_formula_id%type;
456: l_assessment_id per_assessments.assessment_id%type;
457: l_perf_value NUMBER;
458: l_tot_prof_value NUMBER default 0;
459: l_tot_perf_value NUMBER default 0;
460: l_tot_weigh_value NUMBER default 0;

Line 501: select total_score_formula from per_assessment_types, per_assessments

497: end get_objective_score;
498:
499: function get_assessment_score (p_assessment_id NUMBER) return NUMBER IS
500: cursor get_score_formula is
501: select total_score_formula from per_assessment_types, per_assessments
502: where per_assessments.assessment_id = p_assessment_id
503: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
504: cursor get_competences is
505: select distinct pce.competence_id

Line 502: where per_assessments.assessment_id = p_assessment_id

498:
499: function get_assessment_score (p_assessment_id NUMBER) return NUMBER IS
500: cursor get_score_formula is
501: select total_score_formula from per_assessment_types, per_assessments
502: where per_assessments.assessment_id = p_assessment_id
503: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
504: cursor get_competences is
505: select distinct pce.competence_id
506: from per_competence_elements pce

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

499: function get_assessment_score (p_assessment_id NUMBER) return NUMBER IS
500: cursor get_score_formula is
501: select total_score_formula from per_assessment_types, per_assessments
502: where per_assessments.assessment_id = p_assessment_id
503: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
504: cursor get_competences is
505: select distinct pce.competence_id
506: from per_competence_elements pce
507: where pce.assessment_id = p_assessment_id and pce.type='ASSESSMENT'

Line 512: per_assessments pa

508: and pce.object_name = 'ASSESSOR_ID';
509: cursor get_objectives is
510: select po.objective_id
511: from per_objectives po,
512: per_assessments pa
513: where pa.assessment_id = p_assessment_id
514: and po.appraisal_id = pa.appraisal_id;
515: cursor get_asmnt_type is
516: select nvl(pst.type, 'COMPETENCE'),

Line 519: per_assessments pa

515: cursor get_asmnt_type is
516: select nvl(pst.type, 'COMPETENCE'),
517: pa.appraisal_id
518: from per_assessment_types pst,
519: per_assessments pa
520: where pa.assessment_id = p_assessment_id
521: and pst.assessment_type_id = pa.assessment_type_id;
522: l_num_part NUMBER := 0;
523: l_score_formula per_assessment_types.total_score_formula%type;

Line 580: per_assessments pa

576: cursor get_assessments is
577: select pa.assessment_id,
578: nvl(pst.type, 'COMPETENCE')
579: from per_assessment_types pst,
580: per_assessments pa
581: where pa.appraisal_id = p_appraisal_id
582: and pst.assessment_type_id = pa.assessment_type_id;
583: cursor chk_pce(p_assessment_id NUMBER) IS
584: SELECT 'Y'

Line 594: l_assessment_id per_assessments.assessment_id%type;

590: WHERE pce.assessment_id = p_assessment_id
591: AND pce.type = 'ASSESSMENT'
592: AND pce.object_name = 'ASSESSOR_ID');
593: l_dummy varchar2(1);
594: l_assessment_id per_assessments.assessment_id%type;
595: l_comp_asmt_score NUMBER;
596: l_obj_asmt_score NUMBER;
597: l_asmnt_type per_assessment_types.type%type;
598: begin