APPS.AP_APXVCHCR_XMLP_PKG dependencies on FND_LOOKUPS

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

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

Line 68: l_nls_zero_amt_option fnd_lookups.meaning%TYPE;

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

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

79: ln.meaning,
80: la.displayed_field,
81: lanep.displayed_field
82: INTO nls_yes, nls_no, nls_all, nls_none_ep
83: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la,
84: ap_lookup_codes lanep
85: WHERE ly.lookup_type = 'YES_NO'
86: AND ly.lookup_code = 'Y'
87: AND ln.lookup_type = 'YES_NO'

Line 104: FROM fnd_lookups

100:
101:
102: SELECT meaning
103: INTO l_nls_display_supp_address
104: FROM fnd_lookups
105: WHERE lookup_type = 'YES_NO'
106: AND lookup_code = P_ADDRS_OPTION;
107:
108: C_NLS_ADDR_OPTION := l_nls_display_supp_address;

Line 113: FROM fnd_lookups

109:
110:
111: SELECT meaning
112: INTO l_nls_zero_amt_option
113: FROM fnd_lookups
114: WHERE lookup_type = 'YES_NO'
115: AND lookup_code = P_INCLUDE_ZEROS;
116:
117: C_NLS_ZERO_AMT_OPTION := l_nls_zero_amt_option;