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 324: -- Fetch AR_VAT_TAX details

320: g_jl_exception_type := 'E';
321: app_exception.raise_exception;
322: END IF;
323:
324: -- Fetch AR_VAT_TAX details
325: l_taxable_basis := NULL;
326: l_tax_calculation_plsql_block := NULL;
327: l_tax_type := NULL;
328: l_vat_tax_id := NULL;

Line 346: FROM ar_vat_tax_all_b vat --Bugfix 2367111

342: l_tax_calculation_plsql_block,
343: l_tax_type,
344: l_vat_tax_id,
345: l_tax_category_id
346: FROM ar_vat_tax_all_b vat --Bugfix 2367111
347: WHERE vat.set_of_books_id = l_set_of_books_id
348: AND vat.tax_code = p_tax_code
349: AND p_tax_date BETWEEN vat.start_date
350: AND NVL(vat.end_date, TO_DATE( '31122199', 'DDMMYYYY'))

Line 897: FROM ar_vat_tax_all_b vat --Bugfix 2367111

893: vat.tax_regime_code,
894: vat.tax,
895: vat.tax_status_code,
896: vat.tax_code
897: FROM ar_vat_tax_all_b vat --Bugfix 2367111
898: WHERE vat.set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
899: AND vat.tax_code = l_tax_code
900: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date BETWEEN vat.start_date AND
901: NVL(vat.end_date, TO_DATE('31122199', 'DDMMYYYY'))

Line 1668: AR_VAT_TAX_ALL V

1664: BEGIN
1665: SELECT V.vat_tax_id
1666: INTO l_group_tax_id
1667: FROM RA_CUSTOMER_TRX_LINES_ALL TL,
1668: AR_VAT_TAX_ALL V
1669: WHERE TL.customer_trx_line_id =
1670: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_line_id
1671: AND TL.TAX_CLASSIFICATION_CODE = V.tax_code --TL.vat_tax_id = V.vat_tax_id
1672: AND TL.org_id = V.org_id