DBA Data[Home] [Help]

APPS.AP_APXINVAD_XMLP_PKG dependencies on AP_LOOKUP_CODES

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'