DBA Data[Home] [Help]

APPS.AP_APXINVTC_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 65: 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;

61:
62: END;
63:
64: FUNCTION get_nls_strings RETURN BOOLEAN IS
65: 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;
66: BEGIN
67:
68: SELECT ly.meaning,
69: ln.meaning,

Line 80: ap_lookup_codes l1,

76: nls_void,
77: nls_na
78: FROM fnd_lookups ly,
79: fnd_lookups ln,
80: ap_lookup_codes l1,
81: ap_lookup_codes l2,
82: ap_lookup_codes l3
83: WHERE ly.lookup_type = 'YES_NO'
84: AND ly.lookup_code = 'Y'

Line 81: ap_lookup_codes l2,

77: nls_na
78: FROM fnd_lookups ly,
79: fnd_lookups ln,
80: ap_lookup_codes l1,
81: ap_lookup_codes l2,
82: ap_lookup_codes l3
83: WHERE ly.lookup_type = 'YES_NO'
84: AND ly.lookup_code = 'Y'
85: AND ln.lookup_type = 'YES_NO'

Line 82: ap_lookup_codes l3

78: FROM fnd_lookups ly,
79: fnd_lookups ln,
80: ap_lookup_codes l1,
81: ap_lookup_codes l2,
82: ap_lookup_codes l3
83: WHERE ly.lookup_type = 'YES_NO'
84: AND ly.lookup_code = 'Y'
85: AND ln.lookup_type = 'YES_NO'
86: AND ln.lookup_code = 'N'