APPS.JA_CN_UTILITY dependencies on GL_SETS_OF_BOOKS

Line 207: l_Chart_Of_Accounts_Id Gl_Sets_Of_Books.Chart_Of_Accounts_Id%TYPE;

203: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
204: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
205: l_Message VARCHAR2(300);
206:
207: l_Chart_Of_Accounts_Id Gl_Sets_Of_Books.Chart_Of_Accounts_Id%TYPE;
208: l_Ledger_Id Gl_Ledgers.Ledger_Id%TYPE;
209: BEGIN
210:
211: --log the parameters

Line 252: FROM Gl_Sets_Of_Books

248: END;
249: --fetch chart_of_accounts_id
250: SELECT Chart_Of_Accounts_Id
251: INTO l_Chart_Of_Accounts_Id
252: FROM Gl_Sets_Of_Books
253: WHERE Set_Of_Books_Id = l_Ledger_Id;
254: IF (l_Statement_Level >= l_Runtime_Level)
255: THEN
256: Fnd_Log.STRING(l_Statement_Level,

Line 1057: FROM Gl_Sets_Of_Books

1053: WHERE Application_Id = '101'
1054: AND Id_Flex_Code = 'GL#'
1055: AND Id_Flex_Num =
1056: (SELECT Chart_Of_Accounts_Id
1057: FROM Gl_Sets_Of_Books
1058: WHERE Set_Of_Books_Id = p_Set_Of_Bks_Id);
1059:
1060: CURSOR c_Coa_Segments IS
1061: SELECT Application_Column_Name