APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_ASSESSMENT_TYPES

Line 3027: CURSOR check_default_job_competency (p_assessment_type_id per_assessment_types.assessment_type_id%TYPE)

3023: AND NVL (c.date_to, TRUNC (SYSDATE)) >= TRUNC (SYSDATE)
3024: AND a.competence_element_id = ce.parent_competence_element_id
3025: AND ce.competence_id = c.competence_id;
3026:
3027: CURSOR check_default_job_competency (p_assessment_type_id per_assessment_types.assessment_type_id%TYPE)
3028: IS
3029: SELECT default_job_competencies
3030: FROM per_assessment_types
3031: WHERE assessment_type_id = p_assessment_type_id;

Line 3030: FROM per_assessment_types

3026:
3027: CURSOR check_default_job_competency (p_assessment_type_id per_assessment_types.assessment_type_id%TYPE)
3028: IS
3029: SELECT default_job_competencies
3030: FROM per_assessment_types
3031: WHERE assessment_type_id = p_assessment_type_id;
3032:
3033: CURSOR get_scorecard_objectives (p_scorecard_id per_objectives.scorecard_id%TYPE)
3034: IS

Line 3042: FROM per_assessment_types

3038:
3039: CURSOR get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)
3040: IS
3041: SELECT default_job_competencies, assessment_type_id
3042: FROM per_assessment_types
3043: WHERE assessment_type_id = p_assess_templ;
3044:
3045: l_scorecard_info scorecard_info;
3046: no_score_card_with_this_id EXCEPTION;

Line 3094: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;

3090: --l_status_code varchar2(30);
3091: l_duplicate_name_warning BOOLEAN;
3092: l_found_comp BOOLEAN;
3093: --
3094: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
3095: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
3096: BEGIN
3097: --
3098: IF g_dbg

Line 3095: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;

3091: l_duplicate_name_warning BOOLEAN;
3092: l_found_comp BOOLEAN;
3093: --
3094: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
3095: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
3096: BEGIN
3097: --
3098: IF g_dbg
3099: THEN