111: l_item_ft,
112: l_fed_trib,
113: l_sta_trib
114: FROM ar_memo_lines aml,
115: fnd_lookups tn
116: WHERE aml.memo_line_id = p_memo_line_id;
117: EXCEPTION
118: WHEN OTHERS THEN
119: l_item_org := NULL;
336: IF p_lookup_code IS NOT NULL THEN
337: BEGIN
338: SELECT meaning
339: INTO l_meaning
340: FROM fnd_lookups
341: WHERE lookup_code = p_lookup_code
342: AND lookup_type = p_lookup_type
343: AND enabled_flag = 'Y'
344: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE)