APPS.HR_WPM_UTIL dependencies on PER_PERF_MGMT_PLANS

Line 4: FUNCTION is_appraisal_started (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)

1: PACKAGE BODY HR_WPM_UTIL AS
2: /* $Header: hrwpmutl.pkb 120.1 2008/01/17 11:44:59 arumukhe ship $*/
3:
4: FUNCTION is_appraisal_started (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
5: RETURN varchar2
6: IS
7: cursor get_current_plan_appraisals(c_plan_id per_perf_mgmt_plans.plan_id%TYPE)
8: is

Line 7: cursor get_current_plan_appraisals(c_plan_id per_perf_mgmt_plans.plan_id%TYPE)

3:
4: FUNCTION is_appraisal_started (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
5: RETURN varchar2
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