APPS.AP_APXCCOUT_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 276: AP_LOOKUP_CODES LA,

272: INTO CP_NLS_YES,CP_NLS_NO,CP_NLS_ALL,CP_NLS_DISPUTED,CP_NLS_MGR_UNAPPROVED,CP_NLS_AP_UNAPPROVED,CP_NLS_REJECTED
273: FROM
274: FND_LOOKUPS LY,
275: FND_LOOKUPS LN,
276: AP_LOOKUP_CODES LA,
277: AP_LOOKUP_CODES LM,
278: AP_LOOKUP_CODES LP,
279: AP_LOOKUP_CODES LD,
280: AP_LOOKUP_CODES LR

Line 277: AP_LOOKUP_CODES LM,

273: FROM
274: FND_LOOKUPS LY,
275: FND_LOOKUPS LN,
276: AP_LOOKUP_CODES LA,
277: AP_LOOKUP_CODES LM,
278: AP_LOOKUP_CODES LP,
279: AP_LOOKUP_CODES LD,
280: AP_LOOKUP_CODES LR
281: WHERE LY.LOOKUP_TYPE = 'YES_NO'

Line 278: AP_LOOKUP_CODES LP,

274: FND_LOOKUPS LY,
275: FND_LOOKUPS LN,
276: AP_LOOKUP_CODES LA,
277: AP_LOOKUP_CODES LM,
278: AP_LOOKUP_CODES LP,
279: AP_LOOKUP_CODES LD,
280: AP_LOOKUP_CODES LR
281: WHERE LY.LOOKUP_TYPE = 'YES_NO'
282: AND LY.LOOKUP_CODE = 'Y'

Line 279: AP_LOOKUP_CODES LD,

275: FND_LOOKUPS LN,
276: AP_LOOKUP_CODES LA,
277: AP_LOOKUP_CODES LM,
278: AP_LOOKUP_CODES LP,
279: AP_LOOKUP_CODES LD,
280: AP_LOOKUP_CODES LR
281: WHERE LY.LOOKUP_TYPE = 'YES_NO'
282: AND LY.LOOKUP_CODE = 'Y'
283: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 280: AP_LOOKUP_CODES LR

276: AP_LOOKUP_CODES LA,
277: AP_LOOKUP_CODES LM,
278: AP_LOOKUP_CODES LP,
279: AP_LOOKUP_CODES LD,
280: AP_LOOKUP_CODES LR
281: WHERE LY.LOOKUP_TYPE = 'YES_NO'
282: AND LY.LOOKUP_CODE = 'Y'
283: AND LN.LOOKUP_TYPE = 'YES_NO'
284: AND LN.LOOKUP_CODE = 'N'

Line 384: AP_LOOKUP_CODES ALC

380: SELECT
381: ALC.DISPLAYED_FIELD
382: INTO V_DISPLAY_STATUS
383: FROM
384: AP_LOOKUP_CODES ALC
385: WHERE ALC.LOOKUP_TYPE = 'EXPENSE REPORT STATUS'
386: AND ALC.LOOKUP_CODE = C_STATUS;
387: RETURN V_DISPLAY_STATUS;
388: END;

Line 395: AP_LOOKUP_CODES ALC

391: SELECT
392: ALC.DISPLAYED_FIELD
393: INTO V_DISPLAY_STATUS
394: FROM
395: AP_LOOKUP_CODES ALC
396: WHERE ALC.LOOKUP_TYPE = 'SSE_CCARD_TRXN_CATEGORY'
397: AND ALC.LOOKUP_CODE = C_STATUS;
398: RETURN V_DISPLAY_STATUS;
399: END;