APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_SUPPLIERS

Line 239: FROM ap_suppliers vdr, ap_supplier_sites site, fnd_currencies_vl c

235: IF l_expense_check_address_flag IS NOT NULL THEN
236: BEGIN
237: SELECT vdr.vendor_id, site.payment_currency_code, c.name
238: INTO p_vendor_id, p_vend_pay_curr_code, p_vend_pay_curr_name
239: FROM ap_suppliers vdr, ap_supplier_sites site, fnd_currencies_vl c
240: WHERE site.vendor_id = vdr.vendor_id
241: AND (vdr.employee_id = p_employee_id OR (l_vendor_id is not null and l_vendor_id = vdr.vendor_id)) -- Bug 6978871(sodash)
242: AND c.currency_code(+) = site.payment_currency_code
243: AND upper(site.vendor_site_code) =

Line 271: FROM ap_suppliers v,

267: c.name
268: INTO p_vendor_id,
269: p_vend_pay_curr_code,
270: p_vend_pay_curr_name
271: FROM ap_suppliers v,
272: fnd_currencies_vl c
273: WHERE (v.employee_id = p_employee_id OR (l_vendor_id is not null and l_vendor_id = v.vendor_id)) -- Bug 6978871(sodash)
274: AND c.currency_code(+) = v.payment_currency_code;
275: END IF;

Line 303: FROM ap_suppliers PV,

299: SELECT nvl(PV.allow_awt_flag, 'N'),
300: PV.awt_group_id
301: INTO p_ven_allow_awt_flag,
302: p_ven_awt_group_id
303: FROM ap_suppliers PV,
304: ap_expense_report_headers RH
305: WHERE RH.report_header_id = p_report_header_id
306: AND PV.employee_id = RH.employee_id;
307:

Line 331: FROM ap_suppliers

327: -------------------------------------------------------------------
328: BEGIN
329: SELECT vendor_id
330: INTO p_vendor_id
331: FROM ap_suppliers
332: WHERE employee_id = p_employee_id;
333:
334: return TRUE;
335:

Line 378: FROM ap_suppliers

374: -------------------------------------------------------------------
375: BEGIN
376: SELECT accts_pay_code_combination_id
377: INTO p_accts_pay
378: FROM ap_suppliers
379: WHERE vendor_id = p_vendor_id;
380:
381: return TRUE;
382:

Line 942: ap_suppliers PV

938: 0)),
939: 0)
940: INTO p_available_prepays
941: FROM ap_invoices I,
942: ap_suppliers PV
943: WHERE (select sum(aid.prepay_amount_remaining)
944: from ap_invoice_distributions aid
945: where aid.invoice_id = I.invoice_id
946: AND aid.line_type_lookup_code IN ('ITEM','TAX')