APPS.JAI_CMN_MTAX_PKG dependencies on PO_VENDOR_SITES_ALL

Line 603: FROM po_vendor_sites_all A

599: WHERE Vendor_Name = p_vendor_id;
600:
601: CURSOR c_vendor_site_code( p_vendor_site_id IN VARCHAR2) IS
602: SELECT Vendor_Site_Code
603: FROM po_vendor_sites_all A
604: WHERE a.vendor_site_id = p_vendor_site_id;
605:
606: CURSOR c_vendor_id( p_sugg_vendor_name IN VARCHAR2) IS
607: SELECT Vendor_Id

Line 613: FROM Po_Vendor_Sites_All A

609: WHERE Vendor_Name = p_sugg_vendor_name;
610:
611: CURSOR c_vendor_site_id( p_sugg_vendor_loc IN VARCHAR2, p_vendor_id IN NUMBER, p_org_id IN NUMBER) IS
612: SELECT Vendor_Site_Id
613: FROM Po_Vendor_Sites_All A
614: WHERE A.Vendor_Id = p_vendor_id
615: AND A.Vendor_Site_Code = p_sugg_vendor_loc
616: AND (p_org_id IS NULL OR a.org_id = p_org_id);
617:

Line 956: v_supplier_location PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;

952:
953: --*********** for REQUISITION
954: v_currency_code VARCHAR2(4);
955: v_unit_price NUMBER;
956: v_supplier_location PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
957: v_supplier_name PO_VENDORS.VENDOR_NAME%TYPE;
958:
959: j NUMBER; -- used as a temperory variable
960: