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_TAX_DEF dependencies on ZX_TAXES_B_TMP

Line 204: UPDATE ZX_TAXES_B_TMP TAXES

200: arp_util_tax.debug('a:Migrate Recovery Rates');
201: --Bug 12837833
202: --Tail End Processing
203: BEGIN
204: UPDATE ZX_TAXES_B_TMP TAXES
205: SET PRIMARY_REC_TYPE_RULE_FLAG = 'Y',
206: PRIMARY_REC_RATE_DET_RULE_FLAG = 'Y'
207: WHERE EXISTS (SELECT 1
208: FROM ZX_RATES_B zx_rates,

Line 6794: INSERT INTO ZX_TAXES_B_TMP

6790: BEGIN
6791:
6792: IF L_MULTI_ORG_FLAG = 'Y'
6793: THEN
6794: INSERT INTO ZX_TAXES_B_TMP
6795: (
6796: TAX ,
6797: EFFECTIVE_FROM ,
6798: EFFECTIVE_TO ,

Line 7185: INSERT INTO ZX_TAXES_B_TMP

7181:
7182: );
7183: ELSE
7184:
7185: INSERT INTO ZX_TAXES_B_TMP
7186: (
7187: TAX ,
7188: EFFECTIVE_FROM ,
7189: EFFECTIVE_TO ,

Line 7589: INSERT INTO ZX_TAXES_B_TMP

7585:
7586: IF L_MULTI_ORG_FLAG = 'Y'
7587: THEN
7588:
7589: INSERT INTO ZX_TAXES_B_TMP
7590: (
7591: TAX ,
7592: EFFECTIVE_FROM ,
7593: EFFECTIVE_TO ,

Line 8014: INSERT INTO ZX_TAXES_B_TMP

8010: AND global_attribute1 = lookup_code) --Review1 changes
8011: ) lookups;
8012: ELSE
8013:
8014: INSERT INTO ZX_TAXES_B_TMP
8015: (
8016: TAX ,
8017: EFFECTIVE_FROM ,
8018: EFFECTIVE_TO ,

Line 8711: update zx_taxes_b_tmp

8707: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
8708:
8709: BEGIN
8710:
8711: update zx_taxes_b_tmp
8712: set legal_reporting_status_def_val = '000000000000000'
8713: WHERE record_type_code = 'MIGRATED'
8714: AND tax_regime_code in (
8715: select distinct tax_regime_code from zx_regimes_b