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
372: -------------------------------------------------------------------
373: BEGIN
374: SELECT accts_pay_code_combination_id
375: INTO p_code_comb_id
376: FROM ap_supplier_sites
377: WHERE vendor_site_id = p_vendor_site_id;
378:
379: return TRUE;
380:
419: -------------------------------------------------------------------
420: BEGIN
421: SELECT pay_group_lookup_code
422: INTO p_pay_group_code
423: FROM ap_supplier_sites
424: WHERE vendor_id = p_vendor_id
425: AND vendor_site_id = p_vendor_site_id;
426:
427: return TRUE;
1010: p_party_site_id IN invIntf_partySiteID default null,
1011: p_terms_id IN AP_TERMS.TERM_ID%TYPE default null
1012: ) RETURN BOOLEAN IS
1013: --------------------------------------------------------------------------------
1014: l_payment_priority ap_supplier_sites_all.payment_priority%TYPE;
1015: BEGIN
1016: -- Bug 6838894
1017: -- Bug: 7234744 populate terms-id in the interface table.
1018: BEGIN
1018: BEGIN
1019: if (p_vendor_site_id IS NOT NULL) then
1020: select payment_priority
1021: into l_payment_priority
1022: from ap_supplier_sites_all
1023: where vendor_site_id = p_vendor_site_id;
1024: else
1025: l_payment_priority := NULL;
1026: end if;