DBA Data[Home] [Help]

APPS.HR_WPM_UTIL dependencies on PER_PERSONAL_SCORECARDS

Line 269: p_personid IN per_personal_scorecards.person_id%TYPE,

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
273: IS

Line 1245: FROM per_personal_scorecards pps, per_assignments_f paf,

1241: SELECT 'Y'
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