APPS.AP_APXINVPH_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: APXINVPHB.pls 120.0 2007/12/27 08:06:35 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 227: FROM AP_SYSTEM_PARAMETERS;*/

223:
224: /* commented by raj
225: SELECT sort_by_alternate_field
226: INTO SORT_BY_ALTERNATE
227: FROM AP_SYSTEM_PARAMETERS;*/
228:
229: SELECT sort_by_alternate_field
230: INTO SORT_BY_ALTERNATE_m
231: FROM AP_SYSTEM_PARAMETERS;

Line 231: FROM AP_SYSTEM_PARAMETERS;

227: FROM AP_SYSTEM_PARAMETERS;*/
228:
229: SELECT sort_by_alternate_field
230: INTO SORT_BY_ALTERNATE_m
231: FROM AP_SYSTEM_PARAMETERS;
232:
233:
234: EXCEPTION
235: WHEN OTHERS THEN