323: where organization_id = p_ship_to_org_id
324: and id1= p_ship_to_loc_id;
325:
326: Cursor c_check_vendor IS 327: Select 'x' FROM PO_VENDORS 328: where sysdate between nvl(start_date_active, sysdate)
329: and nvl(end_date_active, sysdate)
330: and vendor_id= p_ship_from_org_id;
331: