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

Line 2251: cursor check_default_job_competency(p_assessment_type_id per_assessment_types.assessment_type_id%TYPE)

2247: and a.competence_element_id = ce.parent_competence_element_id
2248: and ce.competence_id = c.competence_id;
2249:
2250:
2251: cursor check_default_job_competency(p_assessment_type_id per_assessment_types.assessment_type_id%TYPE)
2252: IS
2253: select DEFAULT_JOB_COMPETENCIES from per_assessment_types
2254: where assessment_type_id = p_assessment_type_id;
2255:

Line 2253: select DEFAULT_JOB_COMPETENCIES from per_assessment_types

2249:
2250:
2251: cursor check_default_job_competency(p_assessment_type_id per_assessment_types.assessment_type_id%TYPE)
2252: IS
2253: select DEFAULT_JOB_COMPETENCIES from per_assessment_types
2254: where assessment_type_id = p_assessment_type_id;
2255:
2256: cursor get_scorecard_objectives(p_scorecard_id per_objectives.scorecard_id%TYPE)
2257: is

Line 2264: select DEFAULT_JOB_COMPETENCIES, ASSESSMENT_TYPE_ID from per_assessment_types

2260: and APPRAISE_FLAG = 'Y';
2261:
2262: cursor get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)
2263: IS
2264: select DEFAULT_JOB_COMPETENCIES, ASSESSMENT_TYPE_ID from per_assessment_types
2265: where ASSESSMENT_TYPE_ID = p_assess_templ;
2266:
2267: l_scorecard_info scorecard_info;
2268: NO_SCORE_CARD_WITH_THIS_ID EXCEPTION;

Line 2321: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;

2317: --l_status_code varchar2(30);
2318: l_duplicate_name_warning boolean;
2319: l_found_comp boolean;
2320: --
2321: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
2322: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
2323: Begin
2324: --
2325: IF g_dbg THEN op('Entering:'|| l_proc, g_DEBUG_LOG, 10); END IF;

Line 2322: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;

2318: l_duplicate_name_warning boolean;
2319: l_found_comp boolean;
2320: --
2321: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
2322: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
2323: Begin
2324: --
2325: IF g_dbg THEN op('Entering:'|| l_proc, g_DEBUG_LOG, 10); END IF;
2326: --