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