APPS.AP_WORKFLOW_PKG dependencies on AP_LOOKUP_CODES

Line 1360: FROM ap_lookup_codes

1356: END IF;
1357:
1358: SELECT displayed_field
1359: into l_tr_reason
1360: FROM ap_lookup_codes
1361: WHERE lookup_code = l_result(i)
1362: and lookup_type = 'NLS TRANSLATION';
1363:
1364:

Line 1440: FROM ap_lookup_codes

1436: END IF;
1437:
1438: SELECT displayed_field
1439: into l_tr_reason
1440: FROM ap_lookup_codes
1441: WHERE lookup_code = l_result(i)
1442: and lookup_type = 'NLS TRANSLATION';
1443:
1444: END IF; --results

Line 1603: FROM ap_lookup_codes

1599: END IF;
1600:
1601: SELECT displayed_field
1602: into l_tr_reason
1603: FROM ap_lookup_codes
1604: WHERE lookup_code = l_result(i)
1605: and lookup_type = 'NLS TRANSLATION';
1606:
1607: l_debug_info := 'Open Lines Cursor to Update History Tables';

Line 4569: ap_lookup_codes alk,

4565: ahc.hold_instruction
4566: FROM ap_holds_all ah,
4567: ap_invoices_all AI,
4568: po_vendors PV,
4569: ap_lookup_codes alk,
4570: ap_hold_codes ahc
4571: WHERE ah.hold_id = p_hold_id
4572: AND alk.lookup_code = ah.hold_lookup_code
4573: AND AI.invoice_id = ah.invoice_id

Line 4581: l_hold_type ap_lookup_codes.displayed_field%TYPE;

4577: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4578: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4579: l_invoice_description ap_invoices_all.description%TYPE;
4580: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4581: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4582: l_org_id ap_invoices_all.org_id%TYPE;
4583: l_itemkey VARCHAR2(50);
4584: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4585: l_total ap_invoices_all.invoice_amount%TYPE;