DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_TAXES_B_TMP

Line 6763: INSERT INTO ZX_TAXES_B_TMP

6759: BEGIN
6760:
6761: IF L_MULTI_ORG_FLAG = 'Y'
6762: THEN
6763: INSERT INTO ZX_TAXES_B_TMP
6764: (
6765: TAX ,
6766: EFFECTIVE_FROM ,
6767: EFFECTIVE_TO ,

Line 7159: INSERT INTO ZX_TAXES_B_TMP

7155:
7156: );
7157: ELSE
7158:
7159: INSERT INTO ZX_TAXES_B_TMP
7160: (
7161: TAX ,
7162: EFFECTIVE_FROM ,
7163: EFFECTIVE_TO ,

Line 7567: INSERT INTO ZX_TAXES_B_TMP

7563:
7564: IF L_MULTI_ORG_FLAG = 'Y'
7565: THEN
7566:
7567: INSERT INTO ZX_TAXES_B_TMP
7568: (
7569: TAX ,
7570: EFFECTIVE_FROM ,
7571: EFFECTIVE_TO ,

Line 7992: INSERT INTO ZX_TAXES_B_TMP

7988: AND global_attribute1 = lookup_code) --Review1 changes
7989: ) lookups;
7990: ELSE
7991:
7992: INSERT INTO ZX_TAXES_B_TMP
7993: (
7994: TAX ,
7995: EFFECTIVE_FROM ,
7996: EFFECTIVE_TO ,

Line 8689: update zx_taxes_b_tmp

8685: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
8686:
8687: BEGIN
8688:
8689: update zx_taxes_b_tmp
8690: set legal_reporting_status_def_val = '000000000000000'
8691: WHERE record_type_code = 'MIGRATED'
8692: AND tax_regime_code in (
8693: select distinct tax_regime_code from zx_regimes_b