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_WPM_MASS_APR_PUSH dependencies on PER_ASSESSMENT_TYPES

Line 1154: p_assessment_type_id per_assessment_types.assessment_type_id%TYPE

1150: AND a.competence_element_id = ce.parent_competence_element_id
1151: AND ce.competence_id = c.competence_id;
1152:
1153: CURSOR check_default_job_competency (
1154: p_assessment_type_id per_assessment_types.assessment_type_id%TYPE
1155: )
1156: IS
1157: SELECT default_job_competencies
1158: FROM per_assessment_types

Line 1158: FROM per_assessment_types

1154: p_assessment_type_id per_assessment_types.assessment_type_id%TYPE
1155: )
1156: IS
1157: SELECT default_job_competencies
1158: FROM per_assessment_types
1159: WHERE assessment_type_id = p_assessment_type_id;
1160:
1161: CURSOR get_scorecard_objectives (
1162: p_scorecard_id per_objectives.scorecard_id%TYPE

Line 1176: FROM per_assessment_types

1172: p_assess_templ per_appraisal_templates.assessment_type_id%TYPE
1173: )
1174: IS
1175: SELECT default_job_competencies, assessment_type_id
1176: FROM per_assessment_types
1177: WHERE assessment_type_id = p_assess_templ;
1178:
1179: CURSOR get_sec_asg_supervisors (
1180: p_person_id per_all_people_f.person_id%TYPE

Line 1268: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;

1264: --l_status_code varchar2(30);
1265: l_duplicate_name_warning BOOLEAN;
1266: l_found_comp BOOLEAN;
1267: --
1268: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
1269: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
1270: l_appraisal_period_start_date per_appraisals.appraisal_period_start_date%TYPE;
1271: l_appraisal_date per_appraisals.appraisal_date%TYPE;
1272: l_participant_id per_participants.participant_id%TYPE;

Line 1269: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;

1265: l_duplicate_name_warning BOOLEAN;
1266: l_found_comp BOOLEAN;
1267: --
1268: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
1269: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
1270: l_appraisal_period_start_date per_appraisals.appraisal_period_start_date%TYPE;
1271: l_appraisal_date per_appraisals.appraisal_date%TYPE;
1272: l_participant_id per_participants.participant_id%TYPE;
1273: l_default_participant VARCHAR2 (30)