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_RATES_B_TMP

Line 1009: INTO zx_rates_b_tmp

1005: IF ID_CLASH = 'Y' THEN
1006: IF L_MULTI_ORG_FLAG = 'Y' THEN
1007:
1008: INSERT ALL
1009: INTO zx_rates_b_tmp
1010: (
1011: TAX_RATE_CODE ,
1012: EFFECTIVE_FROM ,
1013: EFFECTIVE_TO ,

Line 1426: INTO zx_rates_b_tmp

1422: where source_id = nvl(p_tax_id,codes.tax_id)
1423: ) ;
1424: ELSE
1425: INSERT ALL
1426: INTO zx_rates_b_tmp
1427: (
1428: TAX_RATE_CODE ,
1429: EFFECTIVE_FROM ,
1430: EFFECTIVE_TO ,

Line 1851: INTO zx_rates_b_tmp

1847:
1848: if l_multi_org_flag = 'Y'
1849: then
1850: INSERT ALL
1851: INTO zx_rates_b_tmp
1852: (
1853: TAX_RATE_CODE ,
1854: EFFECTIVE_FROM ,
1855: EFFECTIVE_TO ,

Line 2275: INTO zx_rates_b_tmp

2271: );
2272: else
2273:
2274: INSERT ALL
2275: INTO zx_rates_b_tmp
2276: (
2277: TAX_RATE_CODE ,
2278: EFFECTIVE_FROM ,
2279: EFFECTIVE_TO ,

Line 2808: INTO zx_rates_b_tmp

2804: --BugFix 3605729
2805: IF ID_CLASH = 'Y' THEN
2806: IF L_MULTI_ORG_FLAG = 'Y' THEN
2807: INSERT ALL
2808: INTO zx_rates_b_tmp
2809: (
2810: TAX_RATE_CODE ,
2811: EFFECTIVE_FROM ,
2812: EFFECTIVE_TO ,

Line 3121: INTO zx_rates_b_tmp

3117: where source_id = nvl(p_tax_id,offset.tax_id)
3118: ) ;
3119: ELSE
3120: INSERT ALL
3121: INTO zx_rates_b_tmp
3122: (
3123: TAX_RATE_CODE ,
3124: EFFECTIVE_FROM ,
3125: EFFECTIVE_TO ,

Line 3441: INTO zx_rates_b_tmp

3437: IF L_MULTI_ORG_FLAG = 'Y'
3438: THEN
3439:
3440: INSERT ALL
3441: INTO zx_rates_b_tmp
3442: (
3443: TAX_RATE_CODE ,
3444: EFFECTIVE_FROM ,
3445: EFFECTIVE_TO ,

Line 3754: INTO zx_rates_b_tmp

3750: )
3751: ;
3752: ELSE
3753: INSERT ALL
3754: INTO zx_rates_b_tmp
3755: (
3756: TAX_RATE_CODE ,
3757: EFFECTIVE_FROM ,
3758: EFFECTIVE_TO ,

Line 4166: INTO zx_rates_b_tmp

4162: --BugFix 3605729
4163: IF ID_CLASH = 'Y' THEN
4164: IF L_MULTI_ORG_FLAG = 'Y' THEN
4165: INSERT ALL
4166: INTO zx_rates_b_tmp
4167: (
4168: TAX_RATE_CODE ,
4169: EFFECTIVE_FROM ,
4170: EFFECTIVE_TO ,

Line 4477: INTO zx_rates_b_tmp

4473: ) ;
4474: ELSE
4475:
4476: INSERT ALL
4477: INTO zx_rates_b_tmp
4478: (
4479: TAX_RATE_CODE ,
4480: EFFECTIVE_FROM ,
4481: EFFECTIVE_TO ,

Line 4793: INTO zx_rates_b_tmp

4789:
4790: IF L_MULTI_ORG_FLAG = 'Y'
4791: THEN
4792: INSERT ALL
4793: INTO zx_rates_b_tmp
4794: (
4795: TAX_RATE_CODE ,
4796: EFFECTIVE_FROM ,
4797: EFFECTIVE_TO ,

Line 5106: INTO zx_rates_b_tmp

5102: ;
5103: ELSE
5104:
5105: INSERT ALL
5106: INTO zx_rates_b_tmp
5107: (
5108: TAX_RATE_CODE ,
5109: EFFECTIVE_FROM ,
5110: EFFECTIVE_TO ,

Line 5538: INSERT INTO zx_rates_b_tmp

5534:
5535: )
5536: LOOP
5537: BEGIN
5538: INSERT INTO zx_rates_b_tmp
5539: (
5540: TAX_RATE_CODE ,
5541: EFFECTIVE_FROM ,
5542: EFFECTIVE_TO ,

Line 5684: AND not exists (select 1 from zx_rates_b_tmp

5680: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
5681: AND codes.tax_id = nvl(rates.source_id, rates.tax_rate_id)
5682: AND rates.record_type_code = 'MIGRATED'
5683: AND ROWNUM = 1
5684: AND not exists (select 1 from zx_rates_b_tmp
5685: where SUBSTRB(tax_rate_code,1,24) = substrb(rates.default_rec_rate_code,1,24) --Bug 4943105
5686: and content_owner_id = rates.content_owner_id
5687: and tax_jurisdiction_code = (SELECT tax_id FROM zx_taxes_b WHERE tax_regime_code = rates.tax_regime_code
5688: AND tax = rates.tax AND content_owner_id = rates.content_owner_id)

Line 5817: INSERT INTO zx_rates_b_tmp

5813:
5814: --For Tax Recovery Rules associated Recovery Rates.
5815: BEGIN
5816:
5817: INSERT INTO zx_rates_b_tmp
5818: (
5819: TAX_RATE_CODE ,
5820: EFFECTIVE_FROM ,
5821: EFFECTIVE_TO ,

Line 6011: INSERT INTO zx_rates_b_tmp

6007: END IF;
6008:
6009: -- For adhoc Recovery Rate creation.
6010: BEGIN
6011: INSERT INTO zx_rates_b_tmp
6012: (
6013: TAX_RATE_CODE ,
6014: EFFECTIVE_FROM ,
6015: EFFECTIVE_TO ,

Line 10778: INTO zx_rates_b_tmp

10774: IF L_MULTI_ORG_FLAG = 'Y'
10775: THEN
10776:
10777: INSERT ALL
10778: INTO zx_rates_b_tmp
10779: (
10780: TAX_RATE_CODE ,
10781: EFFECTIVE_FROM ,
10782: EFFECTIVE_TO ,

Line 11200: INTO zx_rates_b_tmp

11196: ) ;
11197:
11198: ELSE
11199: INSERT ALL
11200: INTO zx_rates_b_tmp
11201: (
11202: TAX_RATE_CODE ,
11203: EFFECTIVE_FROM ,
11204: EFFECTIVE_TO ,

Line 11634: INTO zx_rates_b_tmp

11630: IF L_MULTI_ORG_FLAG = 'Y'
11631: THEN
11632:
11633: INSERT ALL
11634: INTO zx_rates_b_tmp
11635: (
11636: TAX_RATE_CODE ,
11637: EFFECTIVE_FROM ,
11638: EFFECTIVE_TO ,

Line 12058: INTO zx_rates_b_tmp

12054: );
12055: ELSE
12056:
12057: INSERT ALL
12058: INTO zx_rates_b_tmp
12059: (
12060: TAX_RATE_CODE ,
12061: EFFECTIVE_FROM ,
12062: EFFECTIVE_TO ,

Line 12501: INTO zx_rates_b_tmp

12497: IF L_MULTI_ORG_FLAG = 'Y' THEN
12498:
12499: BEGIN
12500: INSERT ALL
12501: INTO zx_rates_b_tmp
12502: (
12503: TAX_RATE_CODE ,
12504: EFFECTIVE_FROM ,
12505: EFFECTIVE_TO ,

Line 12926: INTO zx_rates_b_tmp

12922: END;
12923: ELSE
12924: BEGIN
12925: INSERT ALL
12926: INTO zx_rates_b_tmp
12927: (
12928: TAX_RATE_CODE ,
12929: EFFECTIVE_FROM ,
12930: EFFECTIVE_TO ,

Line 13360: INTO zx_rates_b_tmp

13356: IF L_MULTI_ORG_FLAG = 'Y'
13357: THEN
13358:
13359: INSERT ALL
13360: INTO zx_rates_b_tmp
13361: (
13362: TAX_RATE_CODE ,
13363: EFFECTIVE_FROM ,
13364: EFFECTIVE_TO ,

Line 13784: INTO zx_rates_b_tmp

13780: );
13781: ELSE
13782:
13783: INSERT ALL
13784: INTO zx_rates_b_tmp
13785: (
13786: TAX_RATE_CODE ,
13787: EFFECTIVE_FROM ,
13788: EFFECTIVE_TO ,

Line 14301: update zx_rates_b_tmp rates

14297: /*Stamp the default rate flag correctly for non recovery based rates
14298: Atleast one rate should have this flag set to 'Y' for a given combination
14299: of regime,tax, status and content owner */
14300:
14301: update zx_rates_b_tmp rates
14302: set rates.default_rate_flag = 'Y' ,
14303: rates.default_flg_effective_from = rates.effective_from, --Bug 5104891
14304: rates.default_flg_effective_to = rates.effective_to -- Bug 6680676
14305: where rates.tax_rate_code in ( select rates1.tax_rate_code from zx_rates_b rates1

Line 14331: /* update zx_rates_b_tmp rates

14327: of regime ,tax, status and content owner */
14328:
14329: --Commenting out the logic as it is no longer required
14330: --Bug 5209434
14331: /* update zx_rates_b_tmp rates
14332: set rates.default_rate_flag = 'Y' ,
14333: rates.default_flg_effective_from = rates.effective_from --Bug 5104891
14334: where rates.tax_rate_code in ( select rates1.tax_rate_code from zx_rates_b rates1
14335: where rates.tax_regime_code = rates1.tax_regime_code