112: WHERE invoice_id = pr_new.Invoice_Id;
113:
114: CURSOR fetch_inv_org_id_cur IS
115: SELECT Inventory_Organization_Id
116: FROM Hr_Locations
117: WHERE Location_Id = ( SELECT Ship_To_Location_Id
118: FROM Po_Headers_All
119: WHERE Po_Header_Id = ( SELECT Po_Header_Id
120: FROM Po_Distributions_All