APPS.JAI_PO_PROC_PKG dependencies on PO_VENDOR_SITES_ALL

Line 4048: v_org_id Po_Vendor_Sites_All.org_id%TYPE;

4044: v_created_by po_requisition_lines_all.Created_By%TYPE;
4045: v_last_update_date po_requisition_lines_all.Last_Update_Date%TYPE;
4046: v_last_updated_by po_requisition_lines_all.Last_Updated_By%TYPE;
4047: v_last_update_login po_requisition_lines_all.Last_Update_Login%TYPE;
4048: v_org_id Po_Vendor_Sites_All.org_id%TYPE;
4049: v_operating_id po_requisition_lines_all.ORG_ID%TYPE;
4050: v_deliver_to_loc_id po_requisition_lines_all.DELIVER_TO_LOCATION_ID%TYPE;
4051: v_blanket_hdr po_requisition_lines_all.BLANKET_PO_HEADER_ID%TYPE;
4052: v_blanket_line po_requisition_lines_all.BLANKET_PO_LINE_NUM%TYPE;

Line 4112: FROM Po_Vendor_Sites_All A

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
4112: FROM Po_Vendor_Sites_All A
4113: WHERE A.Vendor_Site_Code = p_sugg_vendor_loc
4114: AND A.Vendor_Id = v_vendor_id
4115: AND (A.Org_Id = v_org_id
4116: OR

Line 4470: FROM Po_Vendor_Sites_All A

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
4470: FROM Po_Vendor_Sites_All A
4471: WHERE A.Vendor_Site_Code = p_sugg_vendor_loc
4472: AND A.Vendor_Id = v_vendor_id
4473: AND (A.Org_Id = v_org_id
4474: OR