DBA Data[Home] [Help]

APPS.BOM_RESOURCES_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 882: SELECT SET_OF_BOOKS_ID INTO book_id FROM ORG_ORGANIZATION_DEFINITIONS

878: FUNCTION Get_UOM_From_GL_Sets_Of_Books(X_Organization_Id NUMBER) RETURN VARCHAR2 IS
879: currency_code VARCHAR2(3);
880: book_id NUMBER;
881: BEGIN
882: SELECT SET_OF_BOOKS_ID INTO book_id FROM ORG_ORGANIZATION_DEFINITIONS
883: WHERE ORGANIZATION_ID = X_Organization_Id;
884: SELECT SUBSTR(CURRENCY_CODE,1,3) INTO currency_code FROM GL_SETS_OF_BOOKS
885: WHERE SET_OF_BOOKS_ID = book_id;
886: RETURN(currency_code);