APPS.PSP_PSPLSODL_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 179: V_EARNINGS_ELEMENT PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

175: RETURN V_EMPLOYEE_NAME;
176: END CF_PERSON_NAMEFORMULA;
177:
178: FUNCTION CF_EARNINGS_ELEMENTFORMULA(ELEMENT_TYPE_ID_V IN NUMBER) RETURN VARCHAR2 IS
179: V_EARNINGS_ELEMENT PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
180: BEGIN
181: IF ELEMENT_TYPE_ID_V IS NULL THEN
182: RETURN (NULL);
183: END IF;

Line 189: PAY_ELEMENT_TYPES_F

185: DISTINCT
186: ELEMENT_NAME
187: INTO V_EARNINGS_ELEMENT
188: FROM
189: PAY_ELEMENT_TYPES_F
190: WHERE ELEMENT_TYPE_ID = ELEMENT_TYPE_ID_V;
191: RETURN V_EARNINGS_ELEMENT;
192: RETURN NULL;
193: EXCEPTION