108: MEANING
109: INTO
110: L_TYPE
111: FROM
112: HR_LOOKUPS
113: WHERE LOOKUP_TYPE = 'CONTRACT_TYPE'
114: AND LOOKUP_CODE = P_CON_TYPE;
115: RETURN (L_TYPE);
116: EXCEPTION
125: MEANING
126: INTO
127: L_UNIT
128: FROM
129: HR_LOOKUPS
130: WHERE LOOKUP_TYPE = 'QUALIFYING_UNITS'
131: AND LOOKUP_CODE = P_EXP_UNITS;
132: RETURN (L_UNIT);
133: EXCEPTION
199: MEANING
200: INTO
201: L_STATUS
202: FROM
203: HR_LOOKUPS
204: WHERE LOOKUP_TYPE = 'SA_EMPLOYMENT_STATUS'
205: AND LOOKUP_CODE = P_EMP_STATUS;
206: RETURN (L_STATUS);
207: EXCEPTION