APPS.JAI_PO_PROC_PKG dependencies on PO_VENDORS

Line 4107: FROM po_vendors

4103: WHERE Requisition_Header_Id = v_header_id;
4104:
4105: CURSOR vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
4106: SELECT vendor_id
4107: FROM po_vendors
4108: WHERE vendor_name = p_sugg_vendor_name;
4109:
4110: CURSOR site_cur(p_sugg_vendor_loc IN VARCHAR2) IS
4111: SELECT Vendor_Site_Id

Line 4465: FROM Po_Vendors

4461: WHERE A.Requisition_Header_Id = p_requisition_Header_Id;
4462:
4463: CURSOR vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
4464: SELECT Vendor_Id
4465: FROM Po_Vendors
4466: WHERE Vendor_Name = p_sugg_vendor_name;
4467:
4468: CURSOR site_cur(p_sugg_vendor_loc IN VARCHAR2) IS
4469: SELECT Vendor_Site_Id

Line 4906: FROM Po_Vendors

4902: WHERE Tax_Id = taxid;
4903:
4904: CURSOR Fetch_Vendor_Id IS
4905: SELECT Vendor_Id
4906: FROM Po_Vendors
4907: WHERE Vendor_Name = v_sugg_vendor_name;
4908:
4909: CURSOR Tot_Amt_Cur IS
4910: SELECT SUM( NVL( Tax_Amount, 0 ) )

Line 8334: FROM Po_Vendors

8330: WHERE Tax_Id = taxid;
8331:
8332: CURSOR Fetch_Vendor_Id IS
8333: SELECT Vendor_Id
8334: FROM Po_Vendors
8335: WHERE Vendor_Name = v_sugg_vendor_name;
8336:
8337: CURSOR Tot_Amt_Cur IS
8338: SELECT SUM( NVL( Tax_Amount, 0 ) )