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.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_TAXES_B

Line 277: | This routine creates records in zx_taxes_b/tl for tax code with tax

273: |
274: | OUT
275: |
276: | DESCRIPTION
277: | This routine creates records in zx_taxes_b/tl for tax code with tax
278: | type = 'LOCATION' and tax code used by tax vendors.
279: | It creates regime, tax, status.
280: |
281: | SCOPE - PUBLIC

Line 473: zx_taxes_b tax

469: SELECT tax_regime_code,tax,party_tax_profile_id,
470: org_id,location_tax_account,set_of_books_id
471: FROM zx_party_tax_profile ptp,
472: ar_system_parameters_all asp,
473: zx_taxes_b tax
474: WHERE ptp.party_type_code = 'OU'
475: AND ptp.party_id = asp.org_id
476: AND asp.tax_database_view_set = 'O'
477: AND tax.tax_regime_code = 'US-SALES-TAX-'|| TO_CHAR(location_structure_id)

Line 539: ** Records in denorm_tbl is used to insert records in zx_regimes_b and zx_taxes_b.

535: ** 101 US CITY COUNTY STATE 200 USD
536: ** 200 US CITY COUNTY STATE 300 USD
537: **
538: **
539: ** Records in denorm_tbl is used to insert records in zx_regimes_b and zx_taxes_b.
540: ** The program creates one regime record for each location structure.
541: ** The program creates as many tax records s as the number of segments in a location structure.
542: **
543: ** If same structure is shared among different OUs

Line 1799: INTO zx_taxes_b_tmp

1795: -- Inserting tax for LOCATION based AR Tax Codes (partition by content_owner_id)
1796: IF L_MULTI_ORG_FLAG = 'Y'
1797: THEN
1798: INSERT ALL
1799: INTO zx_taxes_b_tmp
1800: (
1801: TAX ,
1802: EFFECTIVE_FROM ,
1803: EFFECTIVE_TO ,

Line 2003: ZX_TAXES_B_S.NEXTVAL ,

1999: L_PARENT_GEOGRAPHY_TYPE ,
2000: L_PARENT_GEOGRAPHY_ID ,
2001: L_ALLOW_MASS_CREATE_FLAG ,
2002: L_APPLIED_AMT_HANDLING_FLAG ,
2003: ZX_TAXES_B_S.NEXTVAL ,
2004: L_CONTENT_OWNER_ID ,
2005: L_REP_TAX_AUTHORITY_ID ,
2006: L_COLL_TAX_AUTHORITY_ID ,
2007: L_THRSHLD_CHK_TMPLT_CODE ,

Line 2042: ZX_TAXES_B_S.NEXTVAL ,

2038: LAST_UPDATE_LOGIN
2039: )
2040: VALUES
2041: (
2042: ZX_TAXES_B_S.NEXTVAL ,
2043: USERENV('LANG') ,
2044: USERENV('LANG') ,
2045: 'LOCATION' ,
2046: L_CREATED_BY ,

Line 2160: --ZX_TAXES_B_S.NEXTVAL L_TAX_ID,

2156: WHERE country_code = asp.default_country
2157: AND rownum = 1) L_PARENT_GEOGRAPHY_ID,
2158: 'N' L_ALLOW_MASS_CREATE_FLAG,
2159: 'P' L_APPLIED_AMT_HANDLING_FLAG,
2160: --ZX_TAXES_B_S.NEXTVAL L_TAX_ID,
2161: ptp.party_tax_profile_id L_CONTENT_OWNER_ID,
2162: NULL L_REP_TAX_AUTHORITY_ID,
2163: NULL L_COLL_TAX_AUTHORITY_ID,
2164: NULL L_THRSHLD_CHK_TMPLT_CODE,

Line 2207: FROM zx_taxes_b ztb

2203: ),'-999'
2204: )
2205: )
2206: AND NOT EXISTS (SELECT 1
2207: FROM zx_taxes_b ztb
2208: WHERE ztb.tax_regime_code = zrb.tax_regime_code
2209: AND (ztb.tax = 'LOCATION' or ztb.tax = avt.tax_code)
2210: AND ztb.content_owner_id = ptp.party_tax_profile_id);
2211: ELSE

Line 2214: INTO zx_taxes_b_tmp

2210: AND ztb.content_owner_id = ptp.party_tax_profile_id);
2211: ELSE
2212:
2213: INSERT ALL
2214: INTO zx_taxes_b_tmp
2215: (
2216: TAX ,
2217: EFFECTIVE_FROM ,
2218: EFFECTIVE_TO ,

Line 2418: ZX_TAXES_B_S.NEXTVAL ,

2414: L_PARENT_GEOGRAPHY_TYPE ,
2415: L_PARENT_GEOGRAPHY_ID ,
2416: L_ALLOW_MASS_CREATE_FLAG ,
2417: L_APPLIED_AMT_HANDLING_FLAG ,
2418: ZX_TAXES_B_S.NEXTVAL ,
2419: L_CONTENT_OWNER_ID ,
2420: L_REP_TAX_AUTHORITY_ID ,
2421: L_COLL_TAX_AUTHORITY_ID ,
2422: L_THRSHLD_CHK_TMPLT_CODE ,

Line 2457: ZX_TAXES_B_S.NEXTVAL ,

2453: LAST_UPDATE_LOGIN
2454: )
2455: VALUES
2456: (
2457: ZX_TAXES_B_S.NEXTVAL ,
2458: USERENV('LANG') ,
2459: USERENV('LANG') ,
2460: 'LOCATION' ,
2461: L_CREATED_BY ,

Line 2575: --ZX_TAXES_B_S.NEXTVAL L_TAX_ID,

2571: WHERE country_code = asp.default_country
2572: AND rownum = 1) L_PARENT_GEOGRAPHY_ID,
2573: 'N' L_ALLOW_MASS_CREATE_FLAG,
2574: 'P' L_APPLIED_AMT_HANDLING_FLAG,
2575: --ZX_TAXES_B_S.NEXTVAL L_TAX_ID,
2576: ptp.party_tax_profile_id L_CONTENT_OWNER_ID,
2577: NULL L_REP_TAX_AUTHORITY_ID,
2578: NULL L_COLL_TAX_AUTHORITY_ID,
2579: NULL L_THRSHLD_CHK_TMPLT_CODE,

Line 2623: FROM zx_taxes_b ztb

2619: ),'-999'
2620: )
2621: )
2622: AND NOT EXISTS (SELECT 1
2623: FROM zx_taxes_b ztb
2624: WHERE ztb.tax_regime_code = zrb.tax_regime_code
2625: AND (ztb.tax = 'LOCATION' or ztb.tax = avt.tax_code)
2626: AND ztb.content_owner_id = ptp.party_tax_profile_id);
2627:

Line 2779: FROM zx_taxes_b tax

2775: SYSDATE l_last_update_date,
2776: fnd_global.user_id l_last_updated_by,
2777: fnd_global.conc_login_id l_last_update_login,
2778: fnd_global.conc_request_id l_request_id
2779: FROM zx_taxes_b tax
2780: WHERE tax.tax_regime_code like '%-SALES-TAX-%'
2781: AND NOT EXISTS (SELECT 1
2782: FROM zx_status_b status
2783: WHERE tax.tax_regime_code = status.tax_regime_code

Line 3603: zx_taxes_b tax

3599: SELECT tax_regime_code,tax,party_tax_profile_id,
3600: org_id,location_tax_account,set_of_books_id
3601: FROM zx_party_tax_profile ptp,
3602: ar_system_parameters_all asp,
3603: zx_taxes_b tax
3604: WHERE ptp.party_type_code = 'OU'
3605: AND ptp.party_id = asp.org_id
3606: AND asp.tax_database_view_set IN ('_A','_V')
3607: AND tax.tax_regime_code = 'US-SALES-TAX-'|| TO_CHAR(location_structure_id)

Line 3911: FROM zx_taxes_b

3907: --bug6336567
3908: BEGIN
3909: SELECT tax_account_source_tax
3910: INTO l_tax_acct_source_tax
3911: FROM zx_taxes_b
3912: WHERE tax_regime_code = tax_regime_code_rec(k)
3913: AND tax = 'CITY'
3914: AND record_type_code = 'MIGRATED';
3915: EXCEPTION

Line 4072: FROM zx_taxes_b ztb

4068: SYSDATE l_last_update_date,
4069: fnd_global.user_id l_last_updated_by,
4070: fnd_global.conc_login_id l_last_update_login,
4071: fnd_global.conc_request_id l_request_id
4072: FROM zx_taxes_b ztb
4073: WHERE ztb.tax_regime_code LIKE 'US-SALES-TAX-%'
4074: AND NOT EXISTS (SELECT 1
4075: FROM zx_status_b zsb
4076: WHERE zsb.tax_regime_code = ztb.tax_regime_code

Line 4402: zx_taxes_b ztb

4398: ar_vat_tax_all_b avt,
4399: zx_party_tax_profile ptp,
4400: ar_system_parameters_all asp,
4401: zx_regimes_b zrb,
4402: zx_taxes_b ztb
4403: WHERE ptp.party_type_code = 'OU'
4404: AND ptp.party_id = avt.org_id
4405: AND avt.org_id = asp.org_id
4406: AND asp.tax_database_view_set IN ('_A', '_V')

Line 4734: zx_taxes_b ztb

4730: ar_vat_tax_all_b avt,
4731: zx_party_tax_profile ptp,
4732: ar_system_parameters_all asp,
4733: zx_regimes_b zrb,
4734: zx_taxes_b ztb
4735: WHERE ptp.party_type_code = 'OU'
4736: AND ptp.party_id = l_org_id
4737: AND ptp.party_id = avt.org_id
4738: AND avt.org_id = asp.org_id

Line 6076: l_tax zx_taxes_b.tax%TYPE;

6072: -- ****** VARIABLES ******
6073: l_location_str_id ar_system_parameters_all.location_structure_id%TYPE;
6074: l_org_id ar_vat_tax_all_b.org_id%TYPE;
6075: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
6076: l_tax zx_taxes_b.tax%TYPE;
6077:
6078: BEGIN
6079: IF p_tax_id IS NOT NULL AND p_tax_type = 'LOCATION' THEN
6080: BEGIN

Line 6134: FROM zx_taxes_b ztb,

6130: IF l_tax_regime_code IS NOT NULL THEN
6131: BEGIN
6132: SELECT ztb.tax
6133: INTO l_tax
6134: FROM zx_taxes_b ztb,
6135: zx_party_tax_profile zptp
6136: WHERE ztb.content_owner_id = zptp.party_tax_profile_id
6137: AND zptp.party_type_code = 'OU'
6138: AND zptp.party_id = l_org_id

Line 6213: | This routine is used to insert data into zx_taxes_b for location

6209: |
6210: | OUT
6211: |
6212: | DESCRIPTION
6213: | This routine is used to insert data into zx_taxes_b for location
6214: | segment qualifier. Mainly created for code readability.
6215: |
6216: | SCOPE - PRIVATE
6217: |

Line 6262: FROM zx_taxes_b

6258: AND country_code = p_country_code;
6259:
6260: INSERT ALL
6261: WHEN (NOT EXISTS (SELECT 1
6262: FROM zx_taxes_b
6263: WHERE tax_regime_code = p_tax_regime_code
6264: AND tax = p_seg_att_type
6265: AND content_owner_id = -99
6266: )

Line 6268: INTO ZX_TAXES_B_TMP

6264: AND tax = p_seg_att_type
6265: AND content_owner_id = -99
6266: )
6267: ) THEN
6268: INTO ZX_TAXES_B_TMP
6269: (
6270: TAX ,
6271: EFFECTIVE_FROM ,
6272: EFFECTIVE_TO ,

Line 6493: zx_taxes_b_s.nextval , -- TAX_ID

6489: NULL , -- PARENT_GEOGRAPHY_TYPE
6490: NULL , -- PARENT_GEOGRAPHY_ID
6491: 'Y' , -- ALLOW_MASS_CREATE_FLAG /*Bug fix 552412*/
6492: 'P' , -- APPLIED_AMT_HANDLING_FLAG
6493: zx_taxes_b_s.nextval , -- TAX_ID
6494: -99 , -- CONTENT_OWNER_ID
6495: NULL , -- REP_TAX_AUTHORITY_ID
6496: NULL , -- COLL_TAX_AUTHORITY_ID
6497: NULL , -- THRSHLD_CHK_TMPLT_CODE

Line 6526: FROM zx_taxes_b

6522: )
6523: /*
6524:
6525: WHEN (NOT EXISTS (SELECT 1
6526: FROM zx_taxes_b
6527: WHERE tax_regime_code = p_tax_regime_code
6528: AND tax = p_seg_att_type
6529: AND content_owner_id = -99
6530: )

Line 6554: ZX_TAXES_B_S.NEXTVAL

6550: fnd_global.user_id,
6551: SYSDATE,
6552: fnd_global.user_id,
6553: fnd_global.conc_login_id,
6554: ZX_TAXES_B_S.NEXTVAL
6555: )*/
6556: SELECT 1 FROM DUAL;
6557:
6558: EXCEPTION

Line 7355: | This routine creates records in zx_taxes_b/tl grouping by zx_rates_b

7351: |
7352: | OUT
7353: |
7354: | DESCRIPTION
7355: | This routine creates records in zx_taxes_b/tl grouping by zx_rates_b
7356: |
7357: |
7358: | SCOPE - PRIVATE
7359: |

Line 7382: INSERT INTO ZX_TAXES_B_TMP

7378:
7379: IF L_MULTI_ORG_FLAG = 'Y'
7380: THEN
7381:
7382: INSERT INTO ZX_TAXES_B_TMP
7383: (
7384: TAX ,
7385: EFFECTIVE_FROM ,
7386: EFFECTIVE_TO ,

Line 7634: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

7630: NULL ,--PARENT_GEOGRAPHY_TYPE --YK:8/30/2004: Can be populated for US Sales Tax
7631: NULL ,--PARENT_GEOGRAPHY_ID --YK:8/30/2004: Can be populated for US Sales Tax
7632: 'N' ,--ALLOW_MASS_CREATE_FLAG
7633: 'P' ,--APPLIED_AMT_HANDLING_FLAG --Bug 5232502
7634: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7635: L_CONTENT_OWNER_ID ,
7636: NULL ,--REP_TAX_AUTHORITY_ID
7637: NULL ,--COLL_TAX_AUTHORITY_ID
7638: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 7697: AND not exists (select 1 from zx_taxes_b

7693: --Added following conditions for Sync process
7694: AND results.tax_code_id = nvl(p_tax_id, results.tax_code_id)
7695:
7696: --Rerunability
7697: AND not exists (select 1 from zx_taxes_b
7698: where tax_regime_code = rates.tax_regime_code
7699: and tax = rates.tax
7700: and content_owner_id= rates.content_owner_id
7701: )

Line 7726: from zx_taxes_b tax1

7722: ) TAX
7723: --YK:B:10/07/2004: Added the following condition.
7724: WHERE NOT EXISTS
7725: (select 1
7726: from zx_taxes_b tax1
7727: where tax.l_tax_regime_code = tax1.tax_regime_code
7728: and tax.l_tax = tax1.tax
7729: and tax.l_content_owner_id = tax1.content_owner_id
7730:

Line 7735: INSERT INTO ZX_TAXES_B_TMP

7731: )
7732: ;
7733: ELSE
7734:
7735: INSERT INTO ZX_TAXES_B_TMP
7736: (
7737: TAX ,
7738: EFFECTIVE_FROM ,
7739: EFFECTIVE_TO ,

Line 7987: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

7983: NULL ,--PARENT_GEOGRAPHY_TYPE --YK:8/30/2004: Can be populated for US Sales Tax
7984: NULL ,--PARENT_GEOGRAPHY_ID --YK:8/30/2004: Can be populated for US Sales Tax
7985: 'N' ,--ALLOW_MASS_CREATE_FLAG
7986: 'P' ,--APPLIED_AMT_HANDLING_FLAG --Bug 5232502
7987: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7988: L_CONTENT_OWNER_ID ,
7989: NULL ,--REP_TAX_AUTHORITY_ID
7990: NULL ,--COLL_TAX_AUTHORITY_ID
7991: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 8051: AND not exists (select 1 from zx_taxes_b

8047: --Added following conditions for Sync process
8048: AND results.tax_code_id = nvl(p_tax_id, results.tax_code_id)
8049:
8050: --Rerunability
8051: AND not exists (select 1 from zx_taxes_b
8052: where tax_regime_code = rates.tax_regime_code
8053: and tax = rates.tax
8054: and content_owner_id= rates.content_owner_id
8055: )

Line 8080: from zx_taxes_b tax1

8076: ) TAX
8077: --YK:B:10/07/2004: Added the following condition.
8078: WHERE NOT EXISTS
8079: (select 1
8080: from zx_taxes_b tax1
8081: where tax.l_tax_regime_code = tax1.tax_regime_code
8082: and tax.l_tax = tax1.tax
8083: and tax.l_content_owner_id = tax1.content_owner_id
8084:

Line 8120: ZX_TAXES_B B,

8116: fnd_global.conc_login_id ,
8117: B.TAX_ID
8118: FROM
8119: FND_LANGUAGES L,
8120: ZX_TAXES_B B,
8121: (select rates.tax_regime_code tax_regime_code,
8122: rates.tax tax,
8123: rates.content_owner_id content_owner_id,
8124: categs.description description,

Line 8150: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'

8146: from ZX_TAXES_TL T
8147: where T.TAX_ID = B.TAX_ID
8148: and T.LANGUAGE = L.LANGUAGE_CODE);*/
8149:
8150: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
8151:
8152: update zx_taxes_b_tmp
8153: set legal_reporting_status_def_val = '000000000000000'
8154: WHERE record_type_code = 'MIGRATED'

Line 8152: update zx_taxes_b_tmp

8148: and T.LANGUAGE = L.LANGUAGE_CODE);*/
8149:
8150: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
8151:
8152: update zx_taxes_b_tmp
8153: set legal_reporting_status_def_val = '000000000000000'
8154: WHERE record_type_code = 'MIGRATED'
8155: AND tax_regime_code in (
8156: select distinct tax_regime_code from zx_regimes_b

Line 8175: UPDATE zx_taxes_b_tmp tax SET taxable_basis_rule_flag = 'Y' WHERE

8171: 'SK')
8172: ) ;
8173:
8174: --Bug Fix 5691957
8175: UPDATE zx_taxes_b_tmp tax SET taxable_basis_rule_flag = 'Y' WHERE
8176: EXISTS
8177: (SELECT 1 FROM zx_rates_b rates,ar_vat_tax_all_b codes
8178: WHERE rates.tax_regime_code = tax.tax_regime_code
8179: AND rates.tax = tax.tax

Line 8482: | AR_VAT_TAX_ALL_B.TAX_TYPE --> ZX_TAXES_B.TAX_TYPE_CODE

Line 8825: update zx_taxes_b_tmp

8821: if l_org_id.count <> 0 then
8822: for i in 1..l_org_id.count LOOP
8823: BEGIN
8824:
8825: update zx_taxes_b_tmp
8826: set allow_manual_entry_flag = 'N',
8827: allow_tax_override_flag = 'N',
8828: object_version_number = object_version_number + 1
8829: where content_owner_id = (select party_tax_profile_id from zx_party_tax_profile

Line 8835: arp_util_tax.debug('Failed to update zx_taxes_b due to exception in migrate_profile for org:'

8831: and party_type_code='OU')
8832: and record_type_code='MIGRATED';
8833:
8834: EXCEPTION WHEN OTHERS THEN
8835: arp_util_tax.debug('Failed to update zx_taxes_b due to exception in migrate_profile for org:'
8836: ||l_org_id(i)||sqlerrm);
8837: END;
8838:
8839: BEGIN

Line 9088: THEN SUBSTRB(codes.tax_code, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')

9084: FROM
9085: (
9086: SELECT
9087: CASE WHEN LENGTHB(codes.tax_code) > 30
9088: THEN SUBSTRB(codes.tax_code, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')
9089: ELSE codes.tax_code
9090: END LOOKUP_CODE,
9091: CASE WHEN LENGTHB(codes.tax_code) > 30
9092: THEN codes.tax_code

Line 9374: zx_taxes_b taxes,

9370: fnd_global.user_id ,
9371: fnd_global.conc_login_id ,
9372: taxes.tax_id
9373: FROM
9374: zx_taxes_b taxes,
9375: zx_rates_b rates,
9376: fnd_lookup_values flv,
9377: ar_vat_tax_all_b ar_code
9378: WHERE

Line 9422: zx_taxes_b taxes,

9418: fnd_global.user_id ,
9419: fnd_global.conc_login_id ,
9420: taxes.tax_id
9421: FROM
9422: zx_taxes_b taxes,
9423: zx_rates_b rates,
9424: fnd_lookup_values flv,
9425: ar_vat_tax_all_b ar_code
9426: WHERE

Line 9469: zx_taxes_b taxes,

9465: fnd_global.user_id ,
9466: fnd_global.conc_login_id ,
9467: taxes.tax_id
9468: FROM
9469: zx_taxes_b taxes,
9470: zx_rates_b rates,
9471: fnd_lookup_values flv,
9472: ar_vat_tax_all_b ar_code
9473: WHERE

Line 9520: ZX_TAXES_B B,

9516: fnd_global.conc_login_id ,
9517: B.TAX_ID
9518: FROM
9519: FND_LANGUAGES L,
9520: ZX_TAXES_B B,
9521: zx_rates_b rates,
9522: ar_vat_tax_all_b codes,
9523: jl_zz_ar_tx_categ_all categs
9524: WHERE

Line 9569: ZX_TAXES_B B,

9565: fnd_global.conc_login_id ,
9566: B.TAX_ID
9567: FROM
9568: FND_LANGUAGES L,
9569: ZX_TAXES_B B,
9570: zx_rates_b rates,
9571: ar_vat_tax_all_b codes,
9572: jl_zz_ar_tx_categ_all categs
9573: WHERE

Line 9618: ZX_TAXES_B B,

9614: fnd_global.conc_login_id ,
9615: B.TAX_ID
9616: FROM
9617: FND_LANGUAGES L,
9618: ZX_TAXES_B B,
9619: zx_rates_b rates,
9620: ar_vat_tax_all_b codes,
9621: jl_zz_ar_tx_categ_all categs
9622: WHERE

Line 9667: ZX_TAXES_B B -- cartesian join

9663: L.LANGUAGE_CODE,
9664: userenv('LANG')
9665: FROM
9666: FND_LANGUAGES L,
9667: ZX_TAXES_B B -- cartesian join
9668: WHERE
9669: L.INSTALLED_FLAG in ('I', 'B')
9670: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9671: AND not exists

Line 9727: ZX_TAXES_B B,

9723: fnd_global.conc_login_id ,
9724: B.TAX_ID
9725: FROM
9726: FND_LANGUAGES L,
9727: ZX_TAXES_B B,
9728: (select rates.tax_regime_code tax_regime_code,
9729: rates.tax tax,
9730: rates.content_owner_id content_owner_id,
9731: categs.description description,

Line 10243: | create_zx_taxes failes with unique index zx_taxes_b_u2 violation.

10239: | QCTVQ 204
10240: |
10241: | While createing taxes (create_zx_taxes), tax_precedence is a part
10242: | of grouping criteria. If there're records described above,
10243: | create_zx_taxes failes with unique index zx_taxes_b_u2 violation.
10244: |
10245: |
10246: | SCOPE - PRIVATE
10247: |

Line 10341: UPDATE zx_taxes_b_tmp

10337: l_allow_exceptions_flag
10338: FROM ar_system_parameters_all
10339: WHERE org_id = cursor_rec.party_id;
10340:
10341: UPDATE zx_taxes_b_tmp
10342: SET allow_exemptions_flag = l_allow_exemptions_flag,
10343: allow_exceptions_flag = l_allow_exceptions_flag
10344: WHERE content_owner_id = cursor_rec.party_tax_profile_id
10345: AND record_type_code = 'MIGRATED';