APPS.AP_WEB_AMOUNT_UTIL dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 171: from ap_system_parameters_all asp

167:
168: begin
169: select base_currency_code, asp.set_of_books_id, asp.default_exchange_rate_type
170: into l_curr_code, l_sob_id, l_default_exchange_rate_type
171: from ap_system_parameters_all asp
172: where asp.org_id = p_org_id;
173:
174: p_func_curr_code := l_curr_code;
175: p_sob_id := l_sob_id;

Line 305: ap_system_parameters_all asp,

301:
302: select asp.default_exchange_rate_type
303: into l_exchange_rate_type
304: from per_employees_x pex,
305: ap_system_parameters_all asp,
306: fnd_user fu
307: where
308: pex.set_of_books_id = asp.set_of_books_id and
309: fu.employee_id = pex.employee_id and

Line 386: FROM ap_system_parameters_all

382: END IF;
383: IF (l_sob_id IS NOT NULL AND l_func_curr_code IS NOT NULL) THEN
384: SELECT default_exchange_rate_type
385: INTO l_exchange_rate_type
386: FROM ap_system_parameters_all
387: WHERE set_of_books_id = l_sob_id
388: AND rownum= 1;
389: END IF;
390: EXCEPTION