APPS.ISC_DBI_CURRENCY_PKG dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 99: from ar_system_parameters_all asp,

95: if (p_selected_org <> 'ALL') then
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:

Line 119: from ar_system_parameters_all asp,

115: if(g_common_functional_currency is null) then
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;

Line 179: from ar_system_parameters_all asp,

175: end if;
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:

Line 225: ar_system_parameters_all asp,

221: where not exists (select 1
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

Line 296: from ar_system_parameters_all asp,

292: return '0';
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: