64:
65: END;
66:
67: FUNCTION get_nls_strings RETURN BOOLEAN IS
68: 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 fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
69: BEGIN
70:
71: SELECT ly.meaning,
72: ln.meaning,
77: nls_no,
78: nls_all,
79: nls_void,
80: nls_na
81: FROM fnd_lookups ly,
82: fnd_lookups ln,
83: ap_lookup_codes l1,
84: ap_lookup_codes l2,
85: ap_lookup_codes l3
78: nls_all,
79: nls_void,
80: nls_na
81: FROM fnd_lookups ly,
82: fnd_lookups ln,
83: ap_lookup_codes l1,
84: ap_lookup_codes l2,
85: ap_lookup_codes l3
86: WHERE ly.lookup_type = 'YES_NO'