APPS.GL_LEDGER_UTILS_PKG dependencies on GL_LEDGERS

Line 16: FROM GL_LEDGERS

12: X_Ledger_Currency OUT NOCOPY VARCHAR2,
13: X_Translated_Flag OUT NOCOPY VARCHAR2) IS
14: CURSOR c_ledger IS
15: SELECT ledger_id, decode(object_type_code, 'S', NULL, currency_code), 'N'
16: FROM GL_LEDGERS
17: WHERE short_name = X_Ledger_Short_Name;
18:
19: CURSOR c_ledger_relationship IS
20: SELECT target_ledger_id, target_currency_code,

Line 48: FROM GL_LEDGERS

44: X_Ledger_Short_Name OUT NOCOPY VARCHAR2,
45: X_Translated_Flag OUT NOCOPY VARCHAR2) IS
46: CURSOR c_ledger IS
47: SELECT short_name, 'N'
48: FROM GL_LEDGERS
49: WHERE ledger_id = X_Ledger_Id
50: AND ( object_type_code = 'S'
51: OR decode(X_Ledger_Currency, Null, 'Y', currency_code) =
52: nvl(X_Ledger_Currency, 'Y') );

Line 102: FROM GL_LEDGERS

98: WHERE target_ledger_short_name = X_Ledger_Short_Name;
99:
100: CURSOR c_ledger_set IS
101: SELECT currency_code
102: FROM GL_LEDGERS
103: WHERE ledger_id = (select default_ledger_id
104: from GL_ACCESS_SETS
105: where access_set_id =
106: (select implicit_access_set_id

Line 107: from GL_LEDGERS

103: WHERE ledger_id = (select default_ledger_id
104: from GL_ACCESS_SETS
105: where access_set_id =
106: (select implicit_access_set_id
107: from GL_LEDGERS
108: where short_name = X_Ledger_Short_Name));
109: default_currency VARCHAR2(30);
110: BEGIN
111: OPEN c_ledger;