APPS.HR_WPM_UTIL dependencies on PER_APPRAISAL_PERIODS
Line 10: from per_appraisal_periods
6: IS
7: cursor get_current_plan_appraisals(c_plan_id per_perf_mgmt_plans.plan_id%TYPE)
8: is
9: select distinct 'Y' as if_current 10: from per_appraisal_periods 11: where plan_id = c_plan_id
12: and trunc(sysdate) between nvl(task_start_date,sysdate) and nvl(task_end_date,sysdate);
13:
14: result varchar2(1) default null;