APPS.IGIRGLOBE dependencies on GL_SETS_OF_BOOKS

Line 25: FROM gl_sets_of_books gsob

21:
22: FUNCTION Get_functional_currency RETURN VARCHAR2 IS
23: CURSOR c_sob (cp_sob_id in number) IS
24: SELECT gsob.currency_code
25: FROM gl_sets_of_books gsob
26: WHERE set_of_books_id = cp_sob_id;
27: CURSOR c_sob_id IS
28: SELECT set_of_books_id
29: FROM ar_system_parameters;

Line 43: FROM gl_sets_of_books

39:
40: FUNCTION Get_functional_sob_name Return VARCHAR2 IS
41: CURSOR c_sob_name is
42: SELECT name
43: FROM gl_sets_of_books
44: where set_of_books_id = ( select set_of_books_id from ar_system_parameters );
45:
46: BEGIN
47: FOR l_sob_name in c_sob_name LOOP

Line 121: from gl_sets_of_books

117: )
118: ;
119: cursor c_default_curr is
120: select currency_code
121: from gl_sets_of_books
122: where set_of_books_id in ( select set_of_books_id
123: from ar_system_parameters
124: )
125: ;

Line 165: from gl_sets_of_books

161: )
162: and currency_code is not null
163: union
164: select currency_code
165: from gl_sets_of_books
166: where set_of_books_id =
167: ( select set_of_books_id
168: from ar_system_parameters
169: )