117: --
118: --Cursor to fetch Appraisal Date
119: CURSOR csr_appraisal(p_appraisal_type VARCHAR2) IS
120: SELECT appraisal_id 121: FROM per_appraisals 122: WHERE appraisee_person_id = p_person_id
123: AND type = p_appraisal_type
124: AND appraisal_system_status = p_appraisal_status
125: AND appraisal_date >= NVL(p_appraisal_start_date,HR_GENERAL.start_of_time)