DBA Data[Home] [Help]

APPS.PQH_FR_SPEED dependencies on PER_APPRAISALS

Line 121: FROM per_appraisals

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)