DBA Data[Home] [Help]

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;