[Home] [Help]
391: d PLS_INTEGER;
392: l_temp_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE; --NUMBER;
393: l_temp_seg_num fnd_id_flex_segments.segment_num%TYPE; --NUMBER(15)
394: l_temp_seg_att_type fnd_segment_attribute_values.segment_attribute_type%TYPE; --VARCHAR2(30)
395: l_temp_tax_currency_code ar_system_parameters_all.tax_currency_code%TYPE; --VARCHAR2(15)
396: l_temp_tax_precision ar_system_parameters_all.tax_precision%TYPE; --NUMBER(1)
397: l_temp_tax_mau ar_system_parameters_all.tax_minimum_accountable_unit%TYPE; --NUMBER
398: l_temp_country_code ar_system_parameters_all.default_country%TYPE; --VARCHAR2(60)
399: l_temp_org_id ar_system_parameters_all.org_id%TYPE; --NUMBER(15)
392: l_temp_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE; --NUMBER;
393: l_temp_seg_num fnd_id_flex_segments.segment_num%TYPE; --NUMBER(15)
394: l_temp_seg_att_type fnd_segment_attribute_values.segment_attribute_type%TYPE; --VARCHAR2(30)
395: l_temp_tax_currency_code ar_system_parameters_all.tax_currency_code%TYPE; --VARCHAR2(15)
396: l_temp_tax_precision ar_system_parameters_all.tax_precision%TYPE; --NUMBER(1)
397: l_temp_tax_mau ar_system_parameters_all.tax_minimum_accountable_unit%TYPE; --NUMBER
398: l_temp_country_code ar_system_parameters_all.default_country%TYPE; --VARCHAR2(60)
399: l_temp_org_id ar_system_parameters_all.org_id%TYPE; --NUMBER(15)
400: l_temp_rounding_rule_code ar_system_parameters_all.tax_rounding_rule%TYPE; --VARCHAR2(30)
393: l_temp_seg_num fnd_id_flex_segments.segment_num%TYPE; --NUMBER(15)
394: l_temp_seg_att_type fnd_segment_attribute_values.segment_attribute_type%TYPE; --VARCHAR2(30)
395: l_temp_tax_currency_code ar_system_parameters_all.tax_currency_code%TYPE; --VARCHAR2(15)
396: l_temp_tax_precision ar_system_parameters_all.tax_precision%TYPE; --NUMBER(1)
397: l_temp_tax_mau ar_system_parameters_all.tax_minimum_accountable_unit%TYPE; --NUMBER
398: l_temp_country_code ar_system_parameters_all.default_country%TYPE; --VARCHAR2(60)
399: l_temp_org_id ar_system_parameters_all.org_id%TYPE; --NUMBER(15)
400: l_temp_rounding_rule_code ar_system_parameters_all.tax_rounding_rule%TYPE; --VARCHAR2(30)
401: l_temp_tax_invoice_print ar_system_parameters_all.tax_invoice_print%TYPE; --VARCHAR2(30)
394: l_temp_seg_att_type fnd_segment_attribute_values.segment_attribute_type%TYPE; --VARCHAR2(30)
395: l_temp_tax_currency_code ar_system_parameters_all.tax_currency_code%TYPE; --VARCHAR2(15)
396: l_temp_tax_precision ar_system_parameters_all.tax_precision%TYPE; --NUMBER(1)
397: l_temp_tax_mau ar_system_parameters_all.tax_minimum_accountable_unit%TYPE; --NUMBER
398: l_temp_country_code ar_system_parameters_all.default_country%TYPE; --VARCHAR2(60)
399: l_temp_org_id ar_system_parameters_all.org_id%TYPE; --NUMBER(15)
400: l_temp_rounding_rule_code ar_system_parameters_all.tax_rounding_rule%TYPE; --VARCHAR2(30)
401: l_temp_tax_invoice_print ar_system_parameters_all.tax_invoice_print%TYPE; --VARCHAR2(30)
402: l_temp_allow_rounding_override ar_system_parameters_all.tax_rounding_allow_override%TYPE; --VARCHAR2(30)
395: l_temp_tax_currency_code ar_system_parameters_all.tax_currency_code%TYPE; --VARCHAR2(15)
396: l_temp_tax_precision ar_system_parameters_all.tax_precision%TYPE; --NUMBER(1)
397: l_temp_tax_mau ar_system_parameters_all.tax_minimum_accountable_unit%TYPE; --NUMBER
398: l_temp_country_code ar_system_parameters_all.default_country%TYPE; --VARCHAR2(60)
399: l_temp_org_id ar_system_parameters_all.org_id%TYPE; --NUMBER(15)
400: l_temp_rounding_rule_code ar_system_parameters_all.tax_rounding_rule%TYPE; --VARCHAR2(30)
401: l_temp_tax_invoice_print ar_system_parameters_all.tax_invoice_print%TYPE; --VARCHAR2(30)
402: l_temp_allow_rounding_override ar_system_parameters_all.tax_rounding_allow_override%TYPE; --VARCHAR2(30)
403: --l_temp_tax_account_id ar_vat_tax_all_b.tax_account_id%TYPE; --NUMBER(15)
396: l_temp_tax_precision ar_system_parameters_all.tax_precision%TYPE; --NUMBER(1)
397: l_temp_tax_mau ar_system_parameters_all.tax_minimum_accountable_unit%TYPE; --NUMBER
398: l_temp_country_code ar_system_parameters_all.default_country%TYPE; --VARCHAR2(60)
399: l_temp_org_id ar_system_parameters_all.org_id%TYPE; --NUMBER(15)
400: l_temp_rounding_rule_code ar_system_parameters_all.tax_rounding_rule%TYPE; --VARCHAR2(30)
401: l_temp_tax_invoice_print ar_system_parameters_all.tax_invoice_print%TYPE; --VARCHAR2(30)
402: l_temp_allow_rounding_override ar_system_parameters_all.tax_rounding_allow_override%TYPE; --VARCHAR2(30)
403: --l_temp_tax_account_id ar_vat_tax_all_b.tax_account_id%TYPE; --NUMBER(15)
404: l_temp_seg_name VARCHAR2(30); --Bug 4204464
397: l_temp_tax_mau ar_system_parameters_all.tax_minimum_accountable_unit%TYPE; --NUMBER
398: l_temp_country_code ar_system_parameters_all.default_country%TYPE; --VARCHAR2(60)
399: l_temp_org_id ar_system_parameters_all.org_id%TYPE; --NUMBER(15)
400: l_temp_rounding_rule_code ar_system_parameters_all.tax_rounding_rule%TYPE; --VARCHAR2(30)
401: l_temp_tax_invoice_print ar_system_parameters_all.tax_invoice_print%TYPE; --VARCHAR2(30)
402: l_temp_allow_rounding_override ar_system_parameters_all.tax_rounding_allow_override%TYPE; --VARCHAR2(30)
403: --l_temp_tax_account_id ar_vat_tax_all_b.tax_account_id%TYPE; --NUMBER(15)
404: l_temp_seg_name VARCHAR2(30); --Bug 4204464
405: l_temp_appl_col_name VARCHAR2(30);
398: l_temp_country_code ar_system_parameters_all.default_country%TYPE; --VARCHAR2(60)
399: l_temp_org_id ar_system_parameters_all.org_id%TYPE; --NUMBER(15)
400: l_temp_rounding_rule_code ar_system_parameters_all.tax_rounding_rule%TYPE; --VARCHAR2(30)
401: l_temp_tax_invoice_print ar_system_parameters_all.tax_invoice_print%TYPE; --VARCHAR2(30)
402: l_temp_allow_rounding_override ar_system_parameters_all.tax_rounding_allow_override%TYPE; --VARCHAR2(30)
403: --l_temp_tax_account_id ar_vat_tax_all_b.tax_account_id%TYPE; --NUMBER(15)
404: l_temp_seg_name VARCHAR2(30); --Bug 4204464
405: l_temp_appl_col_name VARCHAR2(30);
406:
440: NULL cross_curr_rate_type
441: FROM fnd_id_flex_structures str,
442: fnd_id_flex_segments segment,
443: fnd_segment_attribute_values qual,
444: ar_system_parameters_all asp,
445: ar_vat_tax_all_b avt,
446: gl_sets_of_books gsob
447: WHERE str.id_flex_code = 'RLOC'
448: AND str.application_id = 222
2094: 'N' L_APPLICABLE_BY_DEFAULT_FLAG --Bug 4905771
2095: FROM
2096: ar_vat_tax_all_b avt,
2097: zx_party_tax_profile ptp,
2098: ar_system_parameters_all asp,
2099: gl_sets_of_books gsob,
2100: zx_regimes_b zrb
2101: WHERE avt.org_id = ptp.party_id
2102: AND ptp.party_type_code = 'OU'
2508: 'N' L_APPLICABLE_BY_DEFAULT_FLAG --Bug 4905771
2509: FROM
2510: ar_vat_tax_all_b avt,
2511: zx_party_tax_profile ptp,
2512: ar_system_parameters_all asp,
2513: gl_sets_of_books gsob,
2514: zx_regimes_b zrb
2515: WHERE avt.org_id = ptp.party_id
2516: AND avt.org_id = l_org_id
3010: FROM
3011: zx_status_b status,
3012: ar_vat_tax_all_b codes,
3013: zx_party_tax_profile ptp,
3014: ar_system_parameters_all asp
3015: WHERE status.tax_regime_code like '%-SALES-TAX-%'
3016: AND status.tax = 'LOCATION'
3017: AND status.tax_status_code = 'STANDARD'
3018: AND status.content_owner_id = ptp.party_tax_profile_id
3345: FROM
3346: zx_status_b status,
3347: ar_vat_tax_all_b codes,
3348: zx_party_tax_profile ptp,
3349: ar_system_parameters_all asp
3350: WHERE status.tax_regime_code like '%-SALES-TAX-%'
3351: AND status.tax = 'LOCATION'
3352: AND status.tax_status_code = 'STANDARD'
3353: AND status.content_owner_id = ptp.party_tax_profile_id
3512: IF L_MULTI_ORG_FLAG = 'Y'
3513: THEN
3514: SELECT min(start_date)
3515: INTO l_min_start_date
3516: FROM ar_system_parameters_all asp,
3517: ar_vat_tax_all_b avtb
3518: WHERE tax_database_view_set = '_A'
3519: AND asp.org_id = avtb.org_id;
3520: ELSE
3519: AND asp.org_id = avtb.org_id;
3520: ELSE
3521: SELECT min(start_date)
3522: INTO l_min_start_date
3523: FROM ar_system_parameters_all asp,
3524: ar_vat_tax_all_b avtb
3525: WHERE tax_database_view_set = '_A'
3526: AND asp.org_id = l_org_id
3527: AND asp.org_id = avtb.org_id;
3534: THEN
3535: SELECT zrb.tax_regime_code
3536: BULK COLLECT INTO tax_regime_code_rec
3537: FROM zx_regimes_b zrb,
3538: ar_system_parameters_all asp
3539: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3540: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3541: AND asp.tax_database_view_set = '_A';
3542: ELSE
3542: ELSE
3543: SELECT zrb.tax_regime_code
3544: BULK COLLECT INTO tax_regime_code_rec
3545: FROM zx_regimes_b zrb,
3546: ar_system_parameters_all asp
3547: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3548: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3549: AND asp.tax_database_view_set = '_A'
3550: AND asp.org_id = l_org_id;
3674: THEN
3675:
3676: SELECT min(start_date)
3677: INTO l_min_start_date
3678: FROM ar_system_parameters_all asp,
3679: ar_vat_tax_all_b avtb
3680: WHERE tax_database_view_set = '_V'
3681: AND asp.org_id = avtb.org_id;
3682:
3683: ELSE
3684:
3685: SELECT min(start_date)
3686: INTO l_min_start_date
3687: FROM ar_system_parameters_all asp,
3688: ar_vat_tax_all_b avtb
3689: WHERE tax_database_view_set = '_V'
3690: AND asp.org_id = l_org_id
3691: AND asp.org_id = avtb.org_id ;
3697: THEN
3698: SELECT zrb.tax_regime_code
3699: BULK COLLECT INTO tax_regime_code_rec
3700: FROM zx_regimes_b zrb,
3701: ar_system_parameters_all asp
3702: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3703: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3704: AND asp.tax_database_view_set = '_V';
3705: ELSE
3706:
3707: SELECT zrb.tax_regime_code
3708: BULK COLLECT INTO tax_regime_code_rec
3709: FROM zx_regimes_b zrb,
3710: ar_system_parameters_all asp
3711: WHERE tax_regime_code LIKE 'US-SALES-TAX-%'
3712: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3713: AND asp.tax_database_view_set = '_V'
3714: AND asp.org_id = l_org_id ;
3947: fnd_global.user_id l_last_updated_by,
3948: fnd_global.conc_login_id l_last_update_login,
3949: fnd_global.conc_request_id l_request_id
3950: FROM zx_taxes_b ztb,
3951: ar_system_parameters_all asp
3952: WHERE ztb.tax_regime_code LIKE 'US-SALES-TAX-%'
3953: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
3954: AND asp.tax_database_view_set IN ('_A', '_V')
3955: AND asp.org_id = asp.org_id
4084: fnd_global.user_id l_last_updated_by,
4085: fnd_global.conc_login_id l_last_update_login,
4086: fnd_global.conc_request_id l_request_id
4087: FROM zx_taxes_b ztb,
4088: ar_system_parameters_all asp
4089: WHERE ztb.tax_regime_code LIKE 'US-SALES-TAX-%'
4090: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
4091: AND asp.tax_database_view_set IN ('_A', '_V')
4092: AND asp.org_id = l_org_id
4419: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4420: FROM
4421: ar_vat_tax_all_b avt,
4422: zx_party_tax_profile ptp,
4423: ar_system_parameters_all asp,
4424: zx_regimes_b zrb,
4425: zx_taxes_b ztb
4426: WHERE ptp.party_type_code = 'OU'
4427: AND ptp.party_id = avt.org_id
4751: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4752: FROM
4753: ar_vat_tax_all_b avt,
4754: zx_party_tax_profile ptp,
4755: ar_system_parameters_all asp,
4756: zx_regimes_b zrb,
4757: zx_taxes_b ztb
4758: WHERE ptp.party_type_code = 'OU'
4759: AND ptp.party_id = l_org_id
4802: org_id_rec,
4803: location_tax_account_rec,
4804: set_of_books_id_rec,
4805: location_structure_id_rec
4806: FROM ar_system_parameters_all asp,
4807: zx_party_tax_profile ptp
4808: WHERE ptp.party_type_code = 'OU'
4809: AND ptp.party_id = asp.org_id
4810: AND asp.tax_database_view_set IN ('_A', '_V');
4819: org_id_rec,
4820: location_tax_account_rec,
4821: set_of_books_id_rec,
4822: location_structure_id_rec
4823: FROM ar_system_parameters_all asp,
4824: zx_party_tax_profile ptp
4825: WHERE ptp.party_type_code = 'OU'
4826: AND ptp.party_id = asp.org_id
4827: AND asp.org_id = l_org_id
5239: FROM
5240: zx_update_criteria_results results,
5241: ar_vat_tax_all_b codes,
5242: zx_party_tax_profile ptp,
5243: ar_system_parameters_all asp --Bug 3985196: Tax Vendor Handling
5244: WHERE
5245: results.tax_code_id = codes.vat_tax_id
5246: AND results.tax_class = 'OUTPUT'
5247: AND codes.tax_type NOT IN ('TAX_GROUP', 'LOCATION')
5586: FROM
5587: zx_update_criteria_results results,
5588: ar_vat_tax_all_b codes,
5589: zx_party_tax_profile ptp,
5590: ar_system_parameters_all asp --Bug 3985196: Tax Vendor Handling
5591: WHERE
5592: results.tax_code_id = codes.vat_tax_id
5593: AND results.tax_class = 'OUTPUT'
5594: AND codes.tax_type NOT IN ('TAX_GROUP', 'LOCATION')
5937: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
5938: FROM
5939: ar_vat_tax_all_b codes,
5940: zx_party_tax_profile ptp,
5941: ar_system_parameters_all params,
5942: jl_zz_ar_tx_categ_all categs
5943: WHERE
5944: codes.tax_type <> 'TAX_GROUP'
5945:
6057: p_tax_type VARCHAR2 DEFAULT NULL
6058: ) RETURN BOOLEAN
6059: AS
6060: -- ****** VARIABLES ******
6061: l_location_str_id ar_system_parameters_all.location_structure_id%TYPE;
6062: l_org_id ar_vat_tax_all_b.org_id%TYPE;
6063: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
6064: l_tax zx_taxes_b.tax%TYPE;
6065:
6071: SELECT asp.location_structure_id,
6072: asp.org_id
6073: INTO l_location_str_id,
6074: l_org_id
6075: FROM ar_system_parameters_all asp,
6076: ar_vat_tax_all_b avt
6077: where avt.org_id = asp.org_id
6078: AND avt.vat_tax_id = nvl(p_tax_id, avt.vat_tax_id)
6079: AND avt.tax_type = 'LOCATION';
6081: SELECT asp.location_structure_id,
6082: asp.org_id
6083: INTO l_location_str_id,
6084: l_org_id
6085: FROM ar_system_parameters_all asp,
6086: ar_vat_tax_all_b avt
6087: where avt.org_id = asp.org_id
6088: AND avt.org_id = l_org_id
6089: AND avt.vat_tax_id = nvl(p_tax_id, avt.vat_tax_id)
6680: ELSE 'Y'
6681: END ALLOW_EXCEPTIONS_FLAG
6682: FROM ZX_RATES_B rates,
6683: AR_VAT_TAX_ALL_B codes,
6684: AR_SYSTEM_PARAMETERS_ALL ar_sys_op
6685: WHERE
6686: rates.record_type_code = 'MIGRATED'
6687: AND codes.vat_tax_id = rates.tax_rate_id
6688: AND codes.org_id = ar_sys_op.org_id
6806: ELSE 'Y'
6807: END ALLOW_EXCEPTIONS_FLAG
6808: FROM ZX_RATES_B rates,
6809: AR_VAT_TAX_ALL_B codes,
6810: AR_SYSTEM_PARAMETERS_ALL ar_sys_op
6811: WHERE
6812: rates.record_type_code = 'MIGRATED'
6813: AND codes.vat_tax_id = rates.tax_rate_id
6814: AND codes.org_id = l_org_id
6938: AR_SYS_OP.TAX_USE_CUSTOMER_EXEMPT_FLAG tax_use_customer_exempt_flag,
6939: AR_SYS_OP.TAX_USE_LOC_EXC_RATE_FLAG tax_use_loc_exc_rate_flag
6940: FROM ZX_RATES_B rates,
6941: AR_VAT_TAX_ALL_B codes,
6942: AR_SYSTEM_PARAMETERS_ALL ar_sys_op,
6943: jl_zz_ar_tx_categ_all categs
6944: WHERE
6945: rates.record_type_code = 'MIGRATED'
6946: AND codes.vat_tax_id = rates.tax_rate_id
7082: ELSE 'Y'
7083: END ALLOW_EXCEPTIONS_FLAG
7084: FROM ZX_RATES_B rates,
7085: AR_VAT_TAX_ALL_B codes,
7086: AR_SYSTEM_PARAMETERS_ALL ar_sys_op
7087: WHERE codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id) --YK:8/30/2004: ID Clash handling
7088: AND codes.global_attribute_category = 'JATW.ARXSUVAT.VAT_TAX' --RP:9/7/2004: Category is different for P2P
7089: AND rates.record_type_code = 'MIGRATED'
7090: AND codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
7232: ELSE 'Y'
7233: END ALLOW_EXCEPTIONS_FLAG
7234: FROM ZX_RATES_B rates,
7235: AR_VAT_TAX_ALL_B codes,
7236: AR_SYSTEM_PARAMETERS_ALL ar_sys_op
7237: WHERE codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id) --YK:8/30/2004: ID Clash handling
7238: AND codes.global_attribute_category = 'JATW.ARXSUVAT.VAT_TAX' --RP:9/7/2004: Category is different for P2P
7239: AND rates.record_type_code = 'MIGRATED'
7240: AND codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
7663: NULL CROSS_CURRENCY_RATE_TYPE
7664: FROM
7665: ZX_RATES_B RATES,
7666: ZX_UPDATE_CRITERIA_RESULTS results,
7667: AR_SYSTEM_PARAMETERS_ALL ARP,
7668: GL_SETS_OF_BOOKS SOB,
7669: ZX_PARTY_TAX_PROFILE PTP
7670: WHERE
7671: -- Bug 4691005 : 1. removed nvl source_id
8016: NULL CROSS_CURRENCY_RATE_TYPE
8017: FROM
8018: ZX_RATES_B RATES,
8019: ZX_UPDATE_CRITERIA_RESULTS results,
8020: AR_SYSTEM_PARAMETERS_ALL ARP,
8021: GL_SETS_OF_BOOKS SOB,
8022: ZX_PARTY_TAX_PROFILE PTP
8023: WHERE
8024: -- Bug 4691005 : 1. removed nvl source_id
8424: lkups.meaning meaning,
8425: codes.global_attribute_category global_attribute_category
8426: from zx_rates_b rates,
8427: ar_vat_tax_all_b codes,
8428: ar_system_parameters_all params,
8429: fnd_lookups lkups
8430: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
8431: AND decode(l_multi_org_flag,'N',l_org_id,codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,params.org_id)
8432: and params.global_attribute13 = lkups.lookup_code
8984: for cursor_rec in
8985: (
8986: select DISTINCT code.tax_code
8987: FROM AR_VAT_TAX_ALL_B CODE,
8988: AR_SYSTEM_PARAMETERS_ALL PARAM
8989: WHERE code.org_id = param.org_id
8990: -- Bug 4905771
8991: -- Eliminating AR Tax Codes created for tax vendor
8992: -- integration
9216: AS
9217: -- ****** CURSORS ******
9218: CURSOR vnd_tax_code_cur (p_tax_id NUMBER) IS
9219: SELECT avt.tax_code
9220: FROM ar_system_parameters_all asp,
9221: ar_vat_tax_all_b avt
9222: WHERE decode(l_multi_org_flag,'N',l_org_id,avt.org_id) = decode(l_multi_org_flag,'N',l_org_id,asp.org_id)
9223: AND avt.vat_tax_id = nvl(p_tax_id, avt.vat_tax_id)
9224: AND asp.default_country = 'US'
10181: avtb.description
10182: FROM
10183: fnd_languages l,
10184: zx_rates_b b,
10185: ar_system_parameters_all asp,
10186: zx_party_tax_profile ptp,
10187: ar_vat_tax_all_b avtb
10188: WHERE
10189: l.installed_flag in ('I', 'B')
10325: ELSE 'Y'
10326: END
10327: INTO l_allow_exemptions_flag,
10328: l_allow_exceptions_flag
10329: FROM ar_system_parameters_all
10330: WHERE org_id = cursor_rec.party_id;
10331:
10332: UPDATE zx_taxes_b_tmp
10333: SET allow_exemptions_flag = l_allow_exemptions_flag,