APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_TAXES_B_TMP

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 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 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 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 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 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 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 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';