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 203: HR_LOOKUPS

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