APPS.AP_APXPAYSC_XMLP_PKG dependencies on FND_CURRENCIES_VL

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;

2: /* $Header: APXPAYSCB.pls 120.0 2007/12/27 08:19:58 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;
7: BEGIN
8:
9: base_curr := '';
10: prec := 0;

Line 22: fnd_currencies_vl c

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

Line 318: prec fnd_currencies_vl.precision%TYPE;

314: END;
315:
316: FUNCTION get_report_curr_data RETURN boolean IS
317:
318: prec fnd_currencies_vl.precision%TYPE;
319: BEGIN
320: prec := 0;
321:
322: SELECT c.precision

Line 324: FROM fnd_currencies_vl c

320: prec := 0;
321:
322: SELECT c.precision
323: INTO prec
324: FROM fnd_currencies_vl c
325: WHERE c.currency_code = p_payment_currency;
326:
327: h_currency := p_payment_currency;
328: h_currency_precision := prec;