APPS.AP_APXINROH_XMLP_PKG dependencies on FND_LOOKUPS

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 82: FROM fnd_lookups ly, fnd_lookups ln,

78: l1.displayed_field,
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'

Line 434: FROM fnd_lookups

430:
431: if p_subtotal_flag is not null then
432: SELECT meaning
433: INTO l_hold_period_option
434: FROM fnd_lookups
435: WHERE lookup_type = 'YES_NO'
436: AND lookup_code = p_subtotal_flag;
437: end if;
438:

Line 450: FROM fnd_lookups

446:
447: if p_hold_desc_flag is not null then
448: SELECT meaning
449: INTO l_include_hold_desc
450: FROM fnd_lookups
451: WHERE lookup_type = 'YES_NO'
452: AND lookup_code = p_hold_desc_flag;
453: end if;
454: