DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on FND_CURRENCIES_VL

Line 56: l_minimum_accountable_unit fnd_currencies_vl.minimum_accountable_unit%type;

52: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
53: l_tax_type ar_vat_tax.tax_type%type;
54: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
55: l_tax_category_id ar_vat_tax.global_attribute1%type;
56: l_minimum_accountable_unit fnd_currencies_vl.minimum_accountable_unit%type;
57: l_precision fnd_currencies_vl.precision%type;
58: --l_site_use_code ra_site_uses.site_use_code%type;
59: l_site_use_id NUMBER;
60: l_global_attribute5 mtl_system_items.global_attribute1%type;

Line 57: l_precision fnd_currencies_vl.precision%type;

53: l_tax_type ar_vat_tax.tax_type%type;
54: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
55: l_tax_category_id ar_vat_tax.global_attribute1%type;
56: l_minimum_accountable_unit fnd_currencies_vl.minimum_accountable_unit%type;
57: l_precision fnd_currencies_vl.precision%type;
58: --l_site_use_code ra_site_uses.site_use_code%type;
59: l_site_use_id NUMBER;
60: l_global_attribute5 mtl_system_items.global_attribute1%type;
61: l_global_attribute6 mtl_system_items.global_attribute2%type;

Line 377: FROM FND_CURRENCIES_VL

373: SELECT MINIMUM_ACCOUNTABLE_UNIT,
374: PRECISION
375: INTO l_minimum_accountable_unit,
376: l_precision
377: FROM FND_CURRENCIES_VL
378: WHERE currency_code = p_currency_code;
379: EXCEPTION
380: WHEN OTHERS THEN
381: l_minimum_accountable_unit := NULL;