929: l_assess_comps_processed competences_tbl;
930: z PLS_INTEGER;
931: l_def_job_comps sel_comp_tab;
932: APPRAISAL_SETUP_ISSUE EXCEPTION;
933: l_appraiser_id per_people_f.person_id%TYPE;
934: l_main_appraiser_id per_people_f.person_id%TYPE;
935: l_found_appraisal_id per_appraisals.appraisal_id%TYPE;
936: l_found_appraisal boolean;
937:
930: z PLS_INTEGER;
931: l_def_job_comps sel_comp_tab;
932: APPRAISAL_SETUP_ISSUE EXCEPTION;
933: l_appraiser_id per_people_f.person_id%TYPE;
934: l_main_appraiser_id per_people_f.person_id%TYPE;
935: l_found_appraisal_id per_appraisals.appraisal_id%TYPE;
936: l_found_appraisal boolean;
937:
938: