[Home] [Help]
256: BEGIN
257: --Bug 13604446: To default the currency properly, when the language changed
258: SELECT vdr.vendor_id, site.payment_currency_code, c.name
259: INTO p_vendor_id, p_vend_pay_curr_code, p_vend_pay_curr_name
260: FROM ap_suppliers vdr, ap_supplier_sites site, fnd_currencies_vl c
261: WHERE site.vendor_id = vdr.vendor_id
262: AND ( (vdr.employee_id = p_employee_id and l_vendor_id is null ) OR (l_vendor_id is not null and l_vendor_id = vdr.vendor_id)) -- Bug 6978871(sodash) ,#12916260
263: AND c.currency_code(+) = site.payment_currency_code
264: AND upper(site.vendor_site_code) IN
288: c.name
289: INTO p_vendor_id,
290: p_vend_pay_curr_code,
291: p_vend_pay_curr_name
292: FROM ap_suppliers v,
293: fnd_currencies_vl c
294: WHERE ( ( v.employee_id = p_employee_id and l_vendor_id is null ) OR (l_vendor_id is not null and l_vendor_id = v.vendor_id)) -- Bug 6978871(sodash),#12916260
295: AND c.currency_code(+) = v.payment_currency_code;
296: END IF;
320: SELECT nvl(PV.allow_awt_flag, 'N'),
321: PV.awt_group_id
322: INTO p_ven_allow_awt_flag,
323: p_ven_awt_group_id
324: FROM ap_suppliers PV,
325: ap_expense_report_headers RH
326: WHERE RH.report_header_id = p_report_header_id
327: AND PV.employee_id = RH.employee_id;
328:
348: -------------------------------------------------------------------
349: BEGIN
350: SELECT vendor_id
351: INTO p_vendor_id
352: FROM ap_suppliers
353: WHERE employee_id = p_employee_id;
354:
355: return TRUE;
356:
395: -------------------------------------------------------------------
396: BEGIN
397: SELECT accts_pay_code_combination_id
398: INTO p_accts_pay
399: FROM ap_suppliers
400: WHERE vendor_id = p_vendor_id;
401:
402: return TRUE;
403:
964: 0)),
965: 0)
966: INTO p_available_prepays
967: FROM ap_invoices I,
968: ap_suppliers PV
969: WHERE (select sum(aid.prepay_amount_remaining)
970: from ap_invoice_distributions aid
971: where aid.invoice_id = I.invoice_id
972: AND aid.line_type_lookup_code IN ('ITEM','TAX')