DBA Data[Home] [Help]

APPS.JAI_PO_LA_TRIGGER_PKG dependencies on HR_LOCATIONS

Line 160: FROM Hr_Locations

156:
157: -- Get the Inventory Organization Id
158: CURSOR Fetch_Org_Id_Cur IS
159: SELECT Inventory_Organization_Id
160: FROM Hr_Locations
161: WHERE Location_Id = v_ship_loc_id;
162:
163: -- Vijay Shankar for Bug# 3184418
164: CURSOR c_tax_modified_flag(p_po_line_id IN NUMBER) IS

Line 566: FROM Hr_Locations

562:
563: -- Get the Inventory Organization Id
564:
565: CURSOR Fetch_Org_Id_Cur IS SELECT Inventory_Organization_Id
566: FROM Hr_Locations
567: WHERE Location_Id = v_ship_loc_id;
568:
569: --Removed cursor CURSOR C_Check_Quot_lines /*Added by nprashar for bug # 9362704*/
570: CURSOR Fetch_UOMCode_Cur( v_temp_uom IN VARCHAR2 ) IS