APPS.ISC_DBI_CURRENCY_PKG dependencies on GL_SETS_OF_BOOKS

Line 100: gl_sets_of_books gsob

96:
97: select gsob.currency_code
98: into l_f_currency_code
99: from ar_system_parameters_all asp,
100: gl_sets_of_books gsob
101: where asp.org_id = p_selected_org
102: and asp.set_of_books_id = gsob.set_of_books_id;
103:
104: if (p_currency_code = l_f_currency_code) then

Line 120: gl_sets_of_books gsob

116:
117: select distinct gsob.currency_code
118: into g_common_functional_currency
119: from ar_system_parameters_all asp,
120: gl_sets_of_books gsob
121: where asp.set_of_books_id = gsob.set_of_books_id
122: and asp.org_id in (select organization_id from per_organization_list where security_profile_id = fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'));
123: end if;
124:

Line 180: gl_sets_of_books gsob

176:
177: select gsob.currency_code
178: into l_f_currency_code
179: from ar_system_parameters_all asp,
180: gl_sets_of_books gsob
181: where asp.org_id = l_ou
182: and asp.set_of_books_id = gsob.set_of_books_id;
183:
184: if (p_currency_code = l_f_currency_code) then

Line 226: gl_sets_of_books gsob,

222: from org_access ora
223: where org.organization_id = ora.organization_id))
224: org,
225: ar_system_parameters_all asp,
226: gl_sets_of_books gsob,
227: hr_organization_information hoi2
228: where '|| l_fnd_prod_grp_filter || ' = asp.org_id
229: and asp.set_of_books_id = gsob.set_of_books_id
230: and (hoi2.org_information_context || '') = ''Accounting Information''

Line 297: gl_sets_of_books gsob

293: end if;
294: select gsob.currency_code
295: into l_f_currency_code
296: from ar_system_parameters_all asp,
297: gl_sets_of_books gsob
298: where asp.org_id = l_ou
299: and asp.set_of_books_id = gsob.set_of_books_id;
300:
301: if (l_f_currency_code = g_global_currency_code and