APPS.AP_IAW_PKG dependencies on AP_LOOKUP_CODES

Line 182: FROM ap_lookup_codes

178: END IF;
179:
180: SELECT displayed_field
181: into l_tr_reason
182: FROM ap_lookup_codes
183: WHERE lookup_code = l_reason(i)
184: and lookup_type = 'NLS TRANSLATION';
185:
186:

Line 255: FROM ap_lookup_codes

251: END IF;
252:
253: SELECT l_tr_reason || ', ' || displayed_field
254: into l_tr_reason
255: FROM ap_lookup_codes
256: WHERE lookup_code = l_reason(i)
257: and lookup_type = 'NLS TRANSLATION';
258:
259: END IF; --results

Line 411: FROM ap_lookup_codes

407: END IF;
408:
409: SELECT displayed_field
410: into l_tr_reason
411: FROM ap_lookup_codes
412: WHERE lookup_code = l_reason(i)
413: and lookup_type = 'NLS TRANSLATION';
414:
415: OPEN matched_lines(l_invoice_id);

Line 5199: FROM ap_lookup_codes

5195: IF ( l_release_lookup_code is not null ) THEN
5196: UPDATE ap_holds_all
5197: SET release_lookup_code = l_release_lookup_code,
5198: release_reason = (SELECT description
5199: FROM ap_lookup_codes
5200: WHERE lookup_code = l_release_lookup_code
5201: AND lookup_type = 'HOLD CODE'),
5202: last_update_date = sysdate,
5203: last_updated_by = 5,