DBA Data[Home] [Help]

APPS.FA_FASUNPLD_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 74: nls_void ap_lookup_codes.displayed_field%TYPE; nls_na ap_lookup_codes.displayed_field%TYPE; nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fa_lookups.meaning%TYPE; nls_no fa_lookups.meaning%TYPE;

70:
71: END;
72:
73: FUNCTION get_nls_strings RETURN BOOLEAN IS
74: nls_void ap_lookup_codes.displayed_field%TYPE; nls_na ap_lookup_codes.displayed_field%TYPE; nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fa_lookups.meaning%TYPE; nls_no fa_lookups.meaning%TYPE;
75: BEGIN
76:
77: SELECT ly.meaning,
78: ln.meaning,

Line 89: ap_lookup_codes l1,

85: nls_void,
86: nls_na
87: FROM fnd_lookups ly,
88: fnd_lookups ln,
89: ap_lookup_codes l1,
90: ap_lookup_codes l2,
91: ap_lookup_codes l3
92: WHERE ly.lookup_type = 'YES_NO'
93: AND ly.lookup_code = 'Y'

Line 90: ap_lookup_codes l2,

86: nls_na
87: FROM fnd_lookups ly,
88: fnd_lookups ln,
89: ap_lookup_codes l1,
90: ap_lookup_codes l2,
91: ap_lookup_codes l3
92: WHERE ly.lookup_type = 'YES_NO'
93: AND ly.lookup_code = 'Y'
94: AND ln.lookup_type = 'YES_NO'

Line 91: ap_lookup_codes l3

87: FROM fnd_lookups ly,
88: fnd_lookups ln,
89: ap_lookup_codes l1,
90: ap_lookup_codes l2,
91: ap_lookup_codes l3
92: WHERE ly.lookup_type = 'YES_NO'
93: AND ly.lookup_code = 'Y'
94: AND ln.lookup_type = 'YES_NO'
95: AND ln.lookup_code = 'N'