APPS.JAI_CMN_MTAX_PKG dependencies on PO_VENDOR_SITES_ALL

Line 466: FROM po_vendor_sites_all A

462: WHERE Vendor_Name = p_vendor_id;
463:
464: CURSOR c_vendor_site_code( p_vendor_site_id IN VARCHAR2) IS
465: SELECT Vendor_Site_Code
466: FROM po_vendor_sites_all A
467: WHERE a.vendor_site_id = p_vendor_site_id;
468:
469: CURSOR c_vendor_id( p_sugg_vendor_name IN VARCHAR2) IS
470: SELECT Vendor_Id

Line 476: FROM Po_Vendor_Sites_All A

472: WHERE Vendor_Name = p_sugg_vendor_name;
473:
474: CURSOR c_vendor_site_id( p_sugg_vendor_loc IN VARCHAR2, p_vendor_id IN NUMBER, p_org_id IN NUMBER) IS
475: SELECT Vendor_Site_Id
476: FROM Po_Vendor_Sites_All A
477: WHERE A.Vendor_Id = p_vendor_id
478: AND A.Vendor_Site_Code = p_sugg_vendor_loc
479: AND (p_org_id IS NULL OR a.org_id = p_org_id);
480:

Line 744: v_supplier_location PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;

740:
741: --*********** for REQUISITION
742: v_currency_code VARCHAR2(4);
743: v_unit_price NUMBER;
744: v_supplier_location PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
745: v_supplier_name PO_VENDORS.VENDOR_NAME%TYPE;
746:
747: j NUMBER; -- used as a temperory variable
748: