APPS.JA_CN_UTILITY dependencies on GL_SETS_OF_BOOKS

Line 197: l_Chart_Of_Accounts_Id Gl_Sets_Of_Books.Chart_Of_Accounts_Id%TYPE;

193: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
194: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
195: l_Message VARCHAR2(300);
196:
197: l_Chart_Of_Accounts_Id Gl_Sets_Of_Books.Chart_Of_Accounts_Id%TYPE;
198: l_Ledger_Id Gl_Ledgers.Ledger_Id%TYPE;
199: BEGIN
200:
201: --log the parameters

Line 242: FROM Gl_Sets_Of_Books

238: END;
239: --fetch chart_of_accounts_id
240: SELECT Chart_Of_Accounts_Id
241: INTO l_Chart_Of_Accounts_Id
242: FROM Gl_Sets_Of_Books
243: WHERE Set_Of_Books_Id = l_Ledger_Id;
244: IF (l_Statement_Level >= l_Runtime_Level)
245: THEN
246: Fnd_Log.STRING(l_Statement_Level,

Line 935: FROM Gl_Sets_Of_Books

931: WHERE Application_Id = '101'
932: AND Id_Flex_Code = 'GL#'
933: AND Id_Flex_Num =
934: (SELECT Chart_Of_Accounts_Id
935: FROM Gl_Sets_Of_Books
936: WHERE Set_Of_Books_Id = p_Set_Of_Bks_Id);
937:
938: CURSOR c_Coa_Segments IS
939: SELECT Application_Column_Name