APPS.AP_APXINVAD_XMLP_PKG dependencies on FND_LOOKUPS

Line 77: nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;

73:
74: END;
75:
76: FUNCTION get_nls_strings RETURN BOOLEAN IS
77: nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
78: BEGIN
79:
80: nls_all := '';
81: nls_yes := '';

Line 88: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la

84: SELECT ly.meaning,
85: ln.meaning,
86: la.displayed_field
87: INTO nls_yes, nls_no, nls_all
88: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la
89: WHERE ly.lookup_type = 'YES_NO'
90: AND ly.lookup_code = 'Y'
91: AND ln.lookup_type = 'YES_NO'
92: AND ln.lookup_code = 'N'

Line 286: from fnd_lookups

282: status VARCHAR2(80);
283: BEGIN
284: select meaning
285: into status
286: from fnd_lookups
287: where lookup_type='SEQ_DOCUMENT_STATUS'
288: and lookup_code='E';
289: return(status);
290: END;

Line 301: from fnd_lookups

297: status VARCHAR2(80);
298: BEGIN
299: select meaning
300: into status
301: from fnd_lookups
302: where lookup_type = 'SEQ_DOCUMENT_STATUS'
303: and lookup_code = 'D';
304: return(status);
305: END;

Line 336: from fnd_lookups

332: status VARCHAR2(80);
333: BEGIN
334: select meaning
335: into status
336: from fnd_lookups
337: where lookup_type = 'SEQ_DOCUMENT_STATUS'
338: and lookup_code = 'N';
339: return(status);
340: END;