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
201: MEANING
202: INTO
203: L_STATUS
204: FROM
205: HR_LOOKUPS
206: WHERE LOOKUP_TYPE = 'SA_EMPLOYMENT_STATUS'
207: AND LOOKUP_CODE = P_EMP_STATUS;
208: RETURN (L_STATUS);
209: EXCEPTION