APPS.AP_APXINLST_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 67: nls_all ap_lookup_codes.displayed_field%TYPE; nls_sort ap_lookup_codes.displayed_field%TYPE;

63:
64: END;
65:
66: FUNCTION get_nls_strings RETURN BOOLEAN IS
67: nls_all ap_lookup_codes.displayed_field%TYPE; nls_sort ap_lookup_codes.displayed_field%TYPE;
68: nls_type ap_lookup_codes.displayed_field%TYPE;
69: nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
70: BEGIN
71:

Line 68: nls_type ap_lookup_codes.displayed_field%TYPE;

64: END;
65:
66: FUNCTION get_nls_strings RETURN BOOLEAN IS
67: nls_all ap_lookup_codes.displayed_field%TYPE; nls_sort ap_lookup_codes.displayed_field%TYPE;
68: nls_type ap_lookup_codes.displayed_field%TYPE;
69: nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
70: BEGIN
71:
72: nls_all := '';

Line 83: ap_lookup_codes l1, ap_lookup_codes l2

79: l2.displayed_field
80: INTO nls_yes, nls_no,
81: nls_all, nls_sort
82: FROM fnd_lookups ly, fnd_lookups ln,
83: ap_lookup_codes l1, ap_lookup_codes l2
84: WHERE ly.lookup_type = 'YES_NO'
85: AND ly.lookup_code = 'Y'
86: AND ln.lookup_type = 'YES_NO'
87: AND ln.lookup_code = 'N'

Line 103: FROM ap_lookup_codes

99: C_NLS_INVOICE_TYPE := C_NLS_ALL;
100: else
101: SELECT displayed_field
102: INTO nls_type
103: FROM ap_lookup_codes
104: WHERE lookup_type = 'INVOICE TYPE'
105: AND lookup_code = P_INVOICE_TYPE;
106:
107: C_NLS_INVOICE_TYPE := nls_type;