APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_TAXES_B_TMP

Line 1713: INTO zx_taxes_b_tmp

1709: -- Inserting tax for LOCATION based AR Tax Codes (partition by content_owner_id)
1710: IF L_MULTI_ORG_FLAG = 'Y'
1711: THEN
1712: INSERT ALL
1713: INTO zx_taxes_b_tmp
1714: (
1715: TAX ,
1716: EFFECTIVE_FROM ,
1717: EFFECTIVE_TO ,

Line 2127: INTO zx_taxes_b_tmp

2123: AND ztb.content_owner_id = ptp.party_tax_profile_id);
2124: ELSE
2125:
2126: INSERT ALL
2127: INTO zx_taxes_b_tmp
2128: (
2129: TAX ,
2130: EFFECTIVE_FROM ,
2131: EFFECTIVE_TO ,

Line 6256: INTO ZX_TAXES_B_TMP

6252: AND tax = p_seg_att_type
6253: AND content_owner_id = -99
6254: )
6255: ) THEN
6256: INTO ZX_TAXES_B_TMP
6257: (
6258: TAX ,
6259: EFFECTIVE_FROM ,
6260: EFFECTIVE_TO ,

Line 7370: INSERT INTO ZX_TAXES_B_TMP

7366:
7367: IF L_MULTI_ORG_FLAG = 'Y'
7368: THEN
7369:
7370: INSERT INTO ZX_TAXES_B_TMP
7371: (
7372: TAX ,
7373: EFFECTIVE_FROM ,
7374: EFFECTIVE_TO ,

Line 7723: INSERT INTO ZX_TAXES_B_TMP

7719: )
7720: ;
7721: ELSE
7722:
7723: INSERT INTO ZX_TAXES_B_TMP
7724: (
7725: TAX ,
7726: EFFECTIVE_FROM ,
7727: EFFECTIVE_TO ,

Line 8140: update zx_taxes_b_tmp

8136: and T.LANGUAGE = L.LANGUAGE_CODE);*/
8137:
8138: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
8139:
8140: update zx_taxes_b_tmp
8141: set legal_reporting_status_def_val = '000000000000000'
8142: WHERE record_type_code = 'MIGRATED'
8143: AND tax_regime_code in (
8144: select distinct tax_regime_code from zx_regimes_b

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

8159: 'SK')
8160: ) ;
8161:
8162: --Bug Fix 5691957
8163: UPDATE zx_taxes_b_tmp tax SET taxable_basis_rule_flag = 'Y' WHERE
8164: EXISTS
8165: (SELECT 1 FROM zx_rates_b rates,ar_vat_tax_all_b codes
8166: WHERE rates.tax_regime_code = tax.tax_regime_code
8167: AND rates.tax = tax.tax

Line 8813: update zx_taxes_b_tmp

8809: if l_org_id.count <> 0 then
8810: for i in 1..l_org_id.count LOOP
8811: BEGIN
8812:
8813: update zx_taxes_b_tmp
8814: set allow_manual_entry_flag = 'N',
8815: allow_tax_override_flag = 'N',
8816: object_version_number = object_version_number + 1
8817: where content_owner_id = (select party_tax_profile_id from zx_party_tax_profile

Line 10332: UPDATE zx_taxes_b_tmp

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,
10334: allow_exceptions_flag = l_allow_exceptions_flag
10335: WHERE content_owner_id = cursor_rec.party_tax_profile_id
10336: AND record_type_code = 'MIGRATED';