DBA Data[Home] [Help]

APPS.PA_PARCPRJR_XMLP_PKG dependencies on FND_LOOKUP_VALUES

Line 232: L_PERSON_TYPE FND_LOOKUP_VALUES.MEANING%TYPE := NULL;

228: RETURN L_PULL_TERM_RES;
229: END CF_PULL_TERM_RESFORMULA;
230:
231: FUNCTION CF_PERSON_TYPEFORMULA RETURN CHAR IS
232: L_PERSON_TYPE FND_LOOKUP_VALUES.MEANING%TYPE := NULL;
233: BEGIN
234: IF P_PERSON_TYPE IS NOT NULL THEN
235: SELECT
236: MEANING

Line 239: FND_LOOKUP_VALUES

235: SELECT
236: MEANING
237: INTO L_PERSON_TYPE
238: FROM
239: FND_LOOKUP_VALUES
240: WHERE LOOKUP_TYPE in ( 'PA_REP_ALL' , 'PERSON_TYPE' )
241: AND LOOKUP_CODE = P_PERSON_TYPE
242: AND LANGUAGE = USERENV('LANG');
243: END IF;