APPS.HR_WPM_UTIL dependencies on PER_APPRAISAL_PERIODS

Line 160: FROM per_appraisal_periods

156: IS
157: CURSOR get_current_plan_appraisals (c_plan_id per_perf_mgmt_plans.plan_id%TYPE)
158: IS
159: SELECT DISTINCT 'Y' AS if_current
160: FROM per_appraisal_periods
161: WHERE plan_id = c_plan_id
162: AND TRUNC (SYSDATE) BETWEEN NVL (task_start_date, SYSDATE)
163: AND NVL (task_end_date, SYSDATE);
164: