APPS.AP_APXVDVSR_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 326: L_NLS_ACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

322: END GET_COMPANY_NAME;
323: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
324: NLS_YES FND_LOOKUPS.MEANING%TYPE;
325: NLS_NO FND_LOOKUPS.MEANING%TYPE;
326: L_NLS_ACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
327: L_NLS_INACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
328: NLS_ACTIVE FND_LOOKUPS.MEANING%TYPE;
329: NLS_ALL FND_LOOKUPS.MEANING%TYPE;
330: BEGIN

Line 327: L_NLS_INACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

323: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
324: NLS_YES FND_LOOKUPS.MEANING%TYPE;
325: NLS_NO FND_LOOKUPS.MEANING%TYPE;
326: L_NLS_ACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
327: L_NLS_INACTIVE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
328: NLS_ACTIVE FND_LOOKUPS.MEANING%TYPE;
329: NLS_ALL FND_LOOKUPS.MEANING%TYPE;
330: BEGIN
331: NLS_YES := '';

Line 346: AP_LOOKUP_CODES LA,

342: INTO NLS_YES,NLS_NO,L_NLS_ACTIVE,L_NLS_INACTIVE,NLS_ACTIVE,NLS_ALL
343: FROM
344: FND_LOOKUPS LY,
345: FND_LOOKUPS LN,
346: AP_LOOKUP_CODES LA,
347: AP_LOOKUP_CODES LI
348: WHERE LY.LOOKUP_TYPE = 'YES_NO'
349: AND LY.LOOKUP_CODE = 'Y'
350: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 347: AP_LOOKUP_CODES LI

343: FROM
344: FND_LOOKUPS LY,
345: FND_LOOKUPS LN,
346: AP_LOOKUP_CODES LA,
347: AP_LOOKUP_CODES LI
348: WHERE LY.LOOKUP_TYPE = 'YES_NO'
349: AND LY.LOOKUP_CODE = 'Y'
350: AND LN.LOOKUP_TYPE = 'YES_NO'
351: AND LN.LOOKUP_CODE = 'N'

Line 463: AP_LOOKUP_CODES

459: SELECT
460: DISPLAYED_FIELD
461: INTO CP_ORDER_BY
462: FROM
463: AP_LOOKUP_CODES
464: WHERE LOOKUP_TYPE = 'ORDER BY'
465: AND LOOKUP_CODE = P_ORDER_BY_PAR;
466: END IF;
467: IF P_PAY_GROUP_PAR IS NOT NULL THEN