APPS.AP_APXINROH_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 69: nls_all ap_lookup_codes.displayed_field%TYPE; nls_na ap_lookup_codes.displayed_field%TYPE; nls_no_desc ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;

65:
66: END;
67:
68: FUNCTION get_nls_strings RETURN BOOLEAN IS
69: nls_all ap_lookup_codes.displayed_field%TYPE; nls_na ap_lookup_codes.displayed_field%TYPE; nls_no_desc ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
70: BEGIN
71:
72: nls_all := '';
73: nls_yes := '';

Line 83: ap_lookup_codes l1, ap_lookup_codes l2,

79: l2.displayed_field,
80: l3.displayed_field
81: INTO nls_yes, nls_no, nls_all, nls_na, nls_no_desc
82: FROM fnd_lookups ly, fnd_lookups ln,
83: ap_lookup_codes l1, ap_lookup_codes l2,
84: ap_lookup_codes l3
85: WHERE ly.lookup_type = 'YES_NO'
86: AND ly.lookup_code = 'Y'
87: AND ln.lookup_type = 'YES_NO'

Line 84: ap_lookup_codes l3

80: l3.displayed_field
81: INTO nls_yes, nls_no, nls_all, nls_na, nls_no_desc
82: FROM fnd_lookups ly, fnd_lookups ln,
83: ap_lookup_codes l1, ap_lookup_codes l2,
84: ap_lookup_codes l3
85: WHERE ly.lookup_type = 'YES_NO'
86: AND ly.lookup_code = 'Y'
87: AND ln.lookup_type = 'YES_NO'
88: AND ln.lookup_code = 'N'

Line 426: FROM ap_lookup_codes

422:
423: if p_order_by is not null then
424: SELECT displayed_field
425: INTO l_order_by
426: FROM ap_lookup_codes
427: WHERE lookup_type = 'RPT ORDER BY'
428: AND lookup_code = p_order_by;
429: end if;
430:

Line 442: FROM ap_lookup_codes

438:
439: if p_date_par is not null then
440: SELECT displayed_field
441: INTO l_due_or_discount
442: FROM ap_lookup_codes
443: WHERE lookup_type = 'DATE RANGE'
444: AND lookup_code = p_date_par;
445: end if;
446: