DBA Data[Home] [Help]

APPS.AP_APXINROH_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 6: base_curr ap_system_parameters.base_currency_code%TYPE; prec fnd_currencies_vl.precision%TYPE; min_au fnd_currencies_vl.minimum_accountable_unit%TYPE; descr fnd_currencies_vl.description%TYPE;

2: /* $Header: APXINROHB.pls 120.1 2008/01/06 11:52:23 vjaganat noship $ */
3:
4: FUNCTION get_base_curr_data RETURN BOOLEAN IS
5:
6: base_curr ap_system_parameters.base_currency_code%TYPE; prec fnd_currencies_vl.precision%TYPE; min_au fnd_currencies_vl.minimum_accountable_unit%TYPE; descr fnd_currencies_vl.description%TYPE;
7: BEGIN
8:
9: base_curr := '';
10: prec := 0;

Line 22: FROM ap_system_parameters p,

18: INTO base_curr,
19: prec,
20: min_au,
21: descr
22: FROM ap_system_parameters p,
23: fnd_currencies_vl c
24: WHERE p.base_currency_code = c.currency_code;
25:
26: c_base_currency_code := base_curr;

Line 228: FROM AP_SYSTEM_PARAMETERS;

224: BEGIN
225:
226: SELECT sort_by_alternate_field
227: INTO SORT_BY_ALTERNATE
228: FROM AP_SYSTEM_PARAMETERS;
229:
230:
231:
232: EXCEPTION