APPS.JAI_CMN_MTAX_PKG dependencies on PO_VENDORS

Line 461: FROM Po_Vendors

457: */
458: --********* for REQUISITIONS
459: CURSOR c_vendor_name( p_vendor_id IN VARCHAR2) IS
460: SELECT vendor_name
461: FROM Po_Vendors
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

Line 471: FROM Po_Vendors

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
471: FROM Po_Vendors
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

Line 745: v_supplier_name PO_VENDORS.VENDOR_NAME%TYPE;

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:
749: /* Bug 5243532. Added by Lakshmi Gopalsami