eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on AR_VAT_TAX

Line 49: l_taxable_basis ar_vat_tax.taxable_basis%type;

45: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
46: l_tax_rule_set ar_system_parameters.global_attribute13%type;
47: l_location_id hr_locations_all.location_id%type;
48: l_org_class hr_locations_all.global_attribute1%type;
49: l_taxable_basis ar_vat_tax.taxable_basis%type;
50: l_tax_calculation_plsql_block
51: ar_vat_tax.tax_calculation_plsql_block%type;
52: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
53: l_tax_type ar_vat_tax.tax_type%type;

Line 51: ar_vat_tax.tax_calculation_plsql_block%type;

47: l_location_id hr_locations_all.location_id%type;
48: l_org_class hr_locations_all.global_attribute1%type;
49: l_taxable_basis ar_vat_tax.taxable_basis%type;
50: l_tax_calculation_plsql_block
51: ar_vat_tax.tax_calculation_plsql_block%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;

Line 53: l_tax_type ar_vat_tax.tax_type%type;

49: l_taxable_basis ar_vat_tax.taxable_basis%type;
50: l_tax_calculation_plsql_block
51: ar_vat_tax.tax_calculation_plsql_block%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;

Line 54: l_vat_tax_id ar_vat_tax.vat_tax_id%type;

50: l_tax_calculation_plsql_block
51: ar_vat_tax.tax_calculation_plsql_block%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;

Line 55: l_tax_category_id ar_vat_tax.global_attribute1%type;

51: ar_vat_tax.tax_calculation_plsql_block%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;

Line 316: -- Fetch AR_VAT_TAX details

312: 'Required Parameter Missing: Tax Code');
313: app_exception.raise_exception;
314: END IF;
315:
316: -- Fetch AR_VAT_TAX details
317: l_taxable_basis := NULL;
318: l_tax_calculation_plsql_block := NULL;
319: l_tax_type := NULL;
320: l_vat_tax_id := NULL;

Line 338: FROM ar_vat_tax_all_b vat --Bugfix 2367111

334: l_tax_calculation_plsql_block,
335: l_tax_type,
336: l_vat_tax_id,
337: l_tax_category_id
338: FROM ar_vat_tax_all_b vat --Bugfix 2367111
339: WHERE vat.set_of_books_id = l_set_of_books_id
340: AND vat.tax_code = p_tax_code
341: AND p_tax_date BETWEEN vat.start_date
342: AND NVL(vat.end_date, TO_DATE( '31122199', 'DDMMYYYY'))

Line 885: FROM ar_vat_tax_all_b vat --Bugfix 2367111

881: vat.tax_regime_code,
882: vat.tax,
883: vat.tax_status_code,
884: vat.tax_code
885: FROM ar_vat_tax_all_b vat --Bugfix 2367111
886: WHERE vat.set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
887: AND vat.tax_code = l_tax_code
888: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date BETWEEN vat.start_date AND
889: NVL(vat.end_date, TO_DATE('31122199', 'DDMMYYYY'))

Line 1650: AR_VAT_TAX_ALL V

1646: BEGIN
1647: SELECT V.vat_tax_id
1648: INTO l_group_tax_id
1649: FROM RA_CUSTOMER_TRX_LINES_ALL TL,
1650: AR_VAT_TAX_ALL V
1651: WHERE TL.customer_trx_line_id =
1652: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_line_id
1653: AND TL.TAX_CLASSIFICATION_CODE = V.tax_code --TL.vat_tax_id = V.vat_tax_id
1654: AND TL.org_id = V.org_id