APPS.AP_WORKFLOW_PKG dependencies on AP_LOOKUP_CODES

Line 1392: FROM ap_lookup_codes

1388: END IF;
1389:
1390: SELECT displayed_field
1391: into l_tr_reason
1392: FROM ap_lookup_codes
1393: WHERE lookup_code = l_result(i)
1394: and lookup_type = 'NLS TRANSLATION';
1395:
1396:

Line 1472: FROM ap_lookup_codes

1468: END IF;
1469:
1470: SELECT displayed_field
1471: into l_tr_reason
1472: FROM ap_lookup_codes
1473: WHERE lookup_code = l_result(i)
1474: and lookup_type = 'NLS TRANSLATION';
1475:
1476: END IF; --results

Line 1635: FROM ap_lookup_codes

1631: END IF;
1632:
1633: SELECT displayed_field
1634: into l_tr_reason
1635: FROM ap_lookup_codes
1636: WHERE lookup_code = l_result(i)
1637: and lookup_type = 'NLS TRANSLATION';
1638:
1639: l_debug_info := 'Open Lines Cursor to Update History Tables';

Line 4701: ap_lookup_codes alk,

4697: ahc.hold_instruction
4698: FROM ap_holds_all ah,
4699: ap_invoices_all AI,
4700: po_vendors PV,
4701: ap_lookup_codes alk,
4702: ap_hold_codes ahc
4703: WHERE ah.hold_id = p_hold_id
4704: AND alk.lookup_code = ah.hold_lookup_code
4705: AND AI.invoice_id = ah.invoice_id

Line 4713: l_hold_type ap_lookup_codes.displayed_field%TYPE;

4709: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4710: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4711: l_invoice_description ap_invoices_all.description%TYPE;
4712: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4713: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4714: l_org_id ap_invoices_all.org_id%TYPE;
4715: l_itemkey VARCHAR2(50);
4716: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4717: l_total ap_invoices_all.invoice_amount%TYPE;