APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on AR_VAT_TAX_ALL_B

Line 2541: FROM ar_vat_tax_all_b

2537: tax_info_rec.tax_calculation_plsql_block, --l_tax_calculation_plsql_block,
2538: tax_info_rec.userf7, --l_tax_type,
2539: tax_info_rec.usern2, --l_vat_tax_id,
2540: tax_info_rec.usern1 --l_tax_category_id
2541: FROM ar_vat_tax_all_b
2542: WHERE set_of_books_id = sysinfo.sysparam.SET_OF_BOOKS_ID
2543: AND tax_code = tax_info_rec.tax_code
2544: AND tax_info_rec.trx_date BETWEEN start_date
2545: AND NVL(end_date, TO_DATE( '31122199', 'DD

Line 2975: FROM ar_vat_tax_all_b

2971: decode(tax_type,
2972: 'LOCATION', TAX_TYPE_LOCATION,
2973: 'SALES_TAX', TAX_TYPE_SALES,
2974: TAX_TYPE_VAT ) tax_type
2975: FROM ar_vat_tax_all_b
2976: WHERE set_of_books_id = c_sob_id
2977: AND tax_code = c_tax_code
2978: AND c_trx_date between start_date and nvl(end_date, c_trx_end_date)
2979: AND nvl(enabled_flag,'Y') = 'Y'

Line 3737: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;

3733: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
3734: l_tax_category_id ar_vat_tax.global_attribute1%type;
3735: l_global_attribute5 mtl_system_items.global_attribute1%type;
3736: l_global_attribute6 mtl_system_items.global_attribute2%type;
3737: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;
3738:
3739:
3740: BEGIN
3741:

Line 3995: FROM ar_vat_tax_all_b

3991: l_tax_calculation_plsql_block,
3992: l_tax_type,
3993: l_vat_tax_id,
3994: l_tax_category_id
3995: FROM ar_vat_tax_all_b
3996: WHERE set_of_books_id = l_set_of_books_id
3997: AND tax_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_index)
3998: AND tax_info_rec.trx_date BETWEEN start_date
3999: AND NVL(end_date, TO_DATE( '31122199', 'DDMMYYYY'))