DBA Data[Home] [Help]

APPS.AP_APXPAYAD_XMLP_PKG dependencies on FND_LOOKUPS

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

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

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

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

Line 285: from fnd_lookups

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

Line 300: from fnd_lookups

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

Line 334: from fnd_lookups

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