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 856: cursor check_default_job_competency(p_assessment_type_id per_assessment_types.assessment_type_id%TYPE)

852: and a.competence_element_id = ce.parent_competence_element_id
853: and ce.competence_id = c.competence_id;
854:
855:
856: cursor check_default_job_competency(p_assessment_type_id per_assessment_types.assessment_type_id%TYPE)
857: IS
858: select DEFAULT_JOB_COMPETENCIES from per_assessment_types
859: where assessment_type_id = p_assessment_type_id;
860:

Line 858: select DEFAULT_JOB_COMPETENCIES from per_assessment_types

854:
855:
856: cursor check_default_job_competency(p_assessment_type_id per_assessment_types.assessment_type_id%TYPE)
857: IS
858: select DEFAULT_JOB_COMPETENCIES from per_assessment_types
859: where assessment_type_id = p_assessment_type_id;
860:
861: cursor get_scorecard_objectives(p_scorecard_id per_objectives.scorecard_id%TYPE)
862: is

Line 869: select DEFAULT_JOB_COMPETENCIES, ASSESSMENT_TYPE_ID from per_assessment_types

865: and APPRAISE_FLAG = 'Y';
866:
867: cursor get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)
868: IS
869: select DEFAULT_JOB_COMPETENCIES, ASSESSMENT_TYPE_ID from per_assessment_types
870: where ASSESSMENT_TYPE_ID = p_assess_templ;
871:
872: cursor find_appraisal(p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
873: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,

Line 948: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;

944: --l_status_code varchar2(30);
945: l_duplicate_name_warning boolean;
946: l_found_comp boolean;
947: --
948: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
949: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
950: l_appraisal_period_start_date per_appraisals.appraisal_period_start_date%TYPE;
951: l_appraisal_date per_appraisals.appraisal_date%TYPE;
952: Begin

Line 949: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;

945: l_duplicate_name_warning boolean;
946: l_found_comp boolean;
947: --
948: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
949: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
950: l_appraisal_period_start_date per_appraisals.appraisal_period_start_date%TYPE;
951: l_appraisal_date per_appraisals.appraisal_date%TYPE;
952: Begin
953: --