DBA Data[Home] [Help]

APPS.JAI_PO_CMN_PKG dependencies on HR_LOCATIONS

Line 314: FROM Hr_Locations

310: v_func_curr Gl_Sets_Of_Books.Currency_Code%TYPE;
311: v_location_id NUMBER;
312:
313: CURSOR Get_Inv_Org_Id_Cur IS SELECT Inventory_Organization_Id
314: FROM Hr_Locations
315: WHERE Location_Id = v_location_id;
316: /* Bug 5243532. Added by Lakshmi Gopalsami
317: * Removed the cursors Get_Set_Of_Book_Cur and
318: * Get_Func_Curr_Cur and implemented caching logic

Line 824: FROM Hr_Locations

820:
821: conv_rate NUMBER;
822:
823: CURSOR Get_Inv_Org_Id_Cur IS SELECT Inventory_Organization_Id
824: FROM Hr_Locations
825: WHERE Location_Id = v_location_id;
826: /* Bug 5243532. Added by Lakshmi Gopalsami
827: * Removed cursors Get_Set_Of_Book_Cur and Get_Func_Curr_Cur
828: * and implemented caching logic