DBA Data[Home] [Help]

APPS.HR_WPM_UTIL dependencies on HR_LOOKUPS

Line 118: FROM hr_lookups

114: IS
115: CURSOR get_appraisal_status (l_appraisal_system_status VARCHAR2)
116: IS
117: SELECT meaning
118: FROM hr_lookups
119: WHERE lookup_type = 'APPRAISAL_SYSTEM_STATUS' AND lookup_code = l_appraisal_system_status;
120:
121: l_rec get_appraisal_info_rec;
122: l_appraisal_system_status VARCHAR2 (80);

Line 270: p_lookupcode IN hr_lookups.lookup_code%TYPE

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
274: RESULT VARCHAR2 (1) := 'N';