DBA Data[Home] [Help]

APPS.AP_APXPAYSC_XMLP_PKG dependencies on AP_LOOKUP_CODES

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

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,

Line 83: ap_lookup_codes l1,

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'
87: AND ly.lookup_code = 'Y'

Line 84: ap_lookup_codes l2,

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'
87: AND ly.lookup_code = 'Y'
88: AND ln.lookup_type = 'YES_NO'

Line 85: ap_lookup_codes l3

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'
87: AND ly.lookup_code = 'Y'
88: AND ln.lookup_type = 'YES_NO'
89: AND ln.lookup_code = 'N'