APPS.IGIRGLOBE dependencies on AR_SYSTEM_PARAMETERS

Line 29: FROM ar_system_parameters;

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;
30: BEGIN
31: FOR l_sob_id in c_sob_id LOOP
32: FOR l_sob IN c_sob ( l_sob_id.set_of_books_id ) LOOP
33: RETURN l_sob.currency_code;

Line 44: where set_of_books_id = ( select set_of_books_id from ar_system_parameters );

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
48: return l_sob_name.name;

Line 60: from ar_system_parameters_all aspa

56: cursor c_ar_system_options is
57: select set_of_books_id, org_id, accounting_method,
58: sysdate creation_date, sysdate last_update_date,
59: -1 last_updated_by, -1 created_by, -1 last_update_login
60: from ar_system_parameters_all aspa
61: where not exists ( select 'Already set up'
62: from igi_ar_system_options_all
63: where set_of_books_id = aspa.set_of_books_id
64: and org_id = aspa.org_id )

Line 96: FROM ar_system_parameters_all

92: DELETE FROM igi_ar_system_options_all a
93: WHERE NOT EXISTS
94: (
95: SELECT 'X'
96: FROM ar_system_parameters_all
97: WHERE org_id = a.org_id
98: AND set_of_books_id = a.set_of_books_id
99: );
100: /* End Bug 3749634 */

Line 123: from ar_system_parameters

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: ;
126: cursor c_customers is
127: select customer_id

Line 168: from ar_system_parameters

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: )
170: )
171: ;
172: