207: WHERE Po_Header_Id = v_po_hdr_id;
208:
209: CURSOR Fetch_Org_Id_Cur IS
210: SELECT Inventory_Organization_Id
211: FROM Hr_Locations
212: WHERE Location_Id = v_ship_loc_id;
213:
214: CURSOR Item_Id_Cur IS
215: SELECT Item_Id, From_Header_Id, From_Line_Id, Line_Num
998: CURSOR fetch_org_id_cur IS
999: SELECT
1000: Inventory_Organization_Id
1001: FROM
1002: hr_locations
1003: WHERE
1004: location_id = v_ship_loc_id;
1005:
1006: