APPS.PER_PERRPREQ_XMLP_PKG dependencies on HR_LOOKUPS

Line 130: FROM hr_lookups

126: BEGIN
127: IF P_VACANCY_STATUS IS NOT NULL THEN
128: SELECT MEANING
129: INTO L_VAC_STATUS
130: FROM hr_lookups
131: WHERE LOOKUP_TYPE = 'VACANCY_STATUS'
132: AND LOOKUP_CODE = P_VACANCY_STATUS;
133: END IF;
134: RETURN L_VAC_STATUS;