DBA Data[Home] [Help]

APPS.PER_PERSACTR_XMLP_PKG dependencies on HR_LOOKUPS

Line 112: HR_LOOKUPS

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

Line 129: HR_LOOKUPS

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

Line 205: HR_LOOKUPS

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