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,
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'
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'
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'