APPS.HR_WPM_UTIL dependencies on PER_PERF_MGMT_PLANS

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

150: THEN
151: RETURN NULL;
152: END;
153:
154: FUNCTION is_appraisal_started (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
155: RETURN VARCHAR2
156: IS
157: CURSOR get_current_plan_appraisals (c_plan_id per_perf_mgmt_plans.plan_id%TYPE)
158: IS

Line 157: CURSOR get_current_plan_appraisals (c_plan_id per_perf_mgmt_plans.plan_id%TYPE)

153:
154: FUNCTION is_appraisal_started (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
155: RETURN VARCHAR2
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

Line 268: p_planid IN per_perf_mgmt_plans.plan_id%TYPE,

264: RAISE;
265: END;
266:
267: FUNCTION enable_share_for_topsupervisor (
268: p_planid IN per_perf_mgmt_plans.plan_id%TYPE,
269: p_personid IN per_personal_scorecards.person_id%TYPE,
270: p_lookupcode IN hr_lookups.lookup_code%TYPE
271: )
272: RETURN VARCHAR2

Line 279: FROM per_perf_mgmt_plans

275: l_personid NUMBER (15, 0) := -1;
276: BEGIN
277: SELECT supervisor_id
278: INTO l_personid
279: FROM per_perf_mgmt_plans
280: WHERE plan_id = p_planid;
281:
282: IF p_personid = l_personid AND p_lookupcode = '3_SHA'
283: THEN

Line 1246: per_perf_mgmt_plans pmp

1242: FROM DUAL
1243: WHERE EXISTS (
1244: SELECT 'x'
1245: FROM per_personal_scorecards pps, per_assignments_f paf,
1246: per_perf_mgmt_plans pmp
1247: WHERE paf.supervisor_id = p_manager_person_id
1248: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND
1249: paf.effective_end_date
1250: AND paf.assignment_id = pps.assignment_id