APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_SUPPLIER_SITES

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 355: FROM ap_supplier_sites

351: -------------------------------------------------------------------
352: BEGIN
353: SELECT accts_pay_code_combination_id
354: INTO p_code_comb_id
355: FROM ap_supplier_sites
356: WHERE vendor_site_id = p_vendor_site_id;
357:
358: return TRUE;
359:

Line 402: FROM ap_supplier_sites

398: -------------------------------------------------------------------
399: BEGIN
400: SELECT pay_group_lookup_code
401: INTO p_pay_group_code
402: FROM ap_supplier_sites
403: WHERE vendor_id = p_vendor_id
404: AND vendor_site_id = p_vendor_site_id;
405:
406: return TRUE;