APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on AR_VAT_TAX_ALL_B

Line 2860: FROM ar_vat_tax_all_b

2856: tax_info_rec.tax_calculation_plsql_block, --l_tax_calculation_plsql_block,
2857: tax_info_rec.userf7, --l_tax_type,
2858: tax_info_rec.usern2, --l_vat_tax_id,
2859: tax_info_rec.usern1 --l_tax_category_id
2860: FROM ar_vat_tax_all_b
2861: WHERE set_of_books_id = sysinfo.sysparam.SET_OF_BOOKS_ID
2862: AND tax_code = tax_info_rec.tax_code
2863: AND tax_info_rec.trx_date BETWEEN start_date
2864: AND NVL(end_date, TO_DATE( '31122199', 'DDMMYYYY'))

Line 3293: FROM ar_vat_tax_all_b

3289: decode(tax_type,
3290: 'LOCATION', TAX_TYPE_LOCATION,
3291: 'SALES_TAX', TAX_TYPE_SALES,
3292: TAX_TYPE_VAT ) tax_type
3293: FROM ar_vat_tax_all_b
3294: WHERE set_of_books_id = c_sob_id
3295: AND tax_code = c_tax_code
3296: AND c_trx_date between start_date and nvl(end_date, c_trx_end_date)
3297: AND nvl(enabled_flag,'Y') = 'Y'

Line 4059: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;

4055: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
4056: l_tax_category_id ar_vat_tax.global_attribute1%type;
4057: l_global_attribute5 mtl_system_items.global_attribute1%type;
4058: l_global_attribute6 mtl_system_items.global_attribute2%type;
4059: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;
4060:
4061: -- Added by ssohal for Bug#8260273
4062: CURSOR get_org_class (c_org_id HR_ORGANIZATION_UNITS.organization_id%TYPE) IS
4063: SELECT HRL.LOCATION_ID,

Line 4411: FROM ar_vat_tax_all_b

4407: l_tax_calculation_plsql_block,
4408: l_tax_type,
4409: l_vat_tax_id,
4410: l_tax_category_id
4411: FROM ar_vat_tax_all_b
4412: WHERE set_of_books_id = l_set_of_books_id
4413: AND tax_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_index)
4414: AND tax_info_rec.trx_date BETWEEN start_date
4415: AND NVL(end_date, TO_DATE( '31122199', 'DDMMYYYY'))