[Home] [Help]
453: CURSOR c_organization IS
454: SELECT hrl.global_attribute6 tax_code,
455: NULL,
456: p_ship_from_warehouse_id
457: FROM hr_locations_all hrl
458: WHERE hrl.location_id = p_warehouse_location_id
459: AND exists (select 1
460: from ar_vat_tax vt
461: WHERE hrl.global_attribute6 = vt.tax_code
481: AND p_trx_date >= NVL(tg.start_date_active, p_trx_date)
482: AND exists (select 1
483: from ar_vat_tax vt1,
484: ar_vat_tax vt,
485: hr_locations_all hrl
486: WHERE hrl.location_id = p_warehouse_location_id
487: AND hrl.global_attribute6 = vt.tax_code
488: AND vt.tax_type = 'TAX_GROUP'
489: AND tg.group_tax_id = vt.vat_tax_id
618: loc.tax_code,
619: loc.base_rate,
620: loc.locn_id
621: FROM jl_zz_ar_tx_locn loc
622: ,hr_locations_all hrl
623: WHERE hrl.location_id = cp_location_id
624: AND loc.ship_from_code = hrl.REGION_2
625: AND loc.tax_category_id = cp_tax_category_id
626: AND cp_trx_date <= loc.end_date_active
661: ,hz_cust_site_uses su
662: ,hz_party_sites p
663: ,hz_locations loc
664: ,ar_system_parameters sp
665: ,hr_locations_all hrl
666: WHERE hrl.location_id = p_warehouse_location_id
667: AND exc.ship_from_code = hrl.REGION_2
668: AND exc.ship_to_segment_id = lv.geography_id
669: AND lv.geography_type = sp.global_attribute9
692: ,hz_cust_site_uses su
693: ,hz_party_sites p
694: ,hz_locations loc
695: ,ar_system_parameters sp
696: ,hr_locations_all hrl
697: WHERE hrl.location_id = p_warehouse_location_id
698: AND exi.ship_from_code = hrl.REGION_2
699: AND exi.ship_to_segment_id = lv.geography_id
700: AND lv.geography_type = sp.global_attribute9
4128: END IF;
4129:
4130: SELECT NVL(global_attribute1,'DEFAULT')
4131: INTO l_organization_class
4132: FROM hr_locations_all
4133: where location_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4;
4134:
4135: IF (g_level_statement >= g_current_runtime_level) THEN
4136: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Organization Class: '||l_organization_class);