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 387: FROM FND_CURRENCIES_VL

383: SELECT MINIMUM_ACCOUNTABLE_UNIT,
384: PRECISION
385: INTO l_minimum_accountable_unit,
386: l_precision
387: FROM FND_CURRENCIES_VL
388: WHERE currency_code = p_currency_code;
389: EXCEPTION
390: WHEN OTHERS THEN
391: l_minimum_accountable_unit := NULL;