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.

[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_RATES_B_TMP

Line 990: INTO zx_rates_b_tmp

986: IF ID_CLASH = 'Y' THEN
987: IF L_MULTI_ORG_FLAG = 'Y' THEN
988:
989: INSERT ALL
990: INTO zx_rates_b_tmp
991: (
992: TAX_RATE_CODE ,
993: EFFECTIVE_FROM ,
994: EFFECTIVE_TO ,

Line 1411: INTO zx_rates_b_tmp

1407: where source_id = nvl(p_tax_id,codes.tax_id)
1408: ) ;
1409: ELSE
1410: INSERT ALL
1411: INTO zx_rates_b_tmp
1412: (
1413: TAX_RATE_CODE ,
1414: EFFECTIVE_FROM ,
1415: EFFECTIVE_TO ,

Line 1840: INTO zx_rates_b_tmp

1836:
1837: if l_multi_org_flag = 'Y'
1838: then
1839: INSERT ALL
1840: INTO zx_rates_b_tmp
1841: (
1842: TAX_RATE_CODE ,
1843: EFFECTIVE_FROM ,
1844: EFFECTIVE_TO ,

Line 2265: INTO zx_rates_b_tmp

2261: );
2262: else
2263:
2264: INSERT ALL
2265: INTO zx_rates_b_tmp
2266: (
2267: TAX_RATE_CODE ,
2268: EFFECTIVE_FROM ,
2269: EFFECTIVE_TO ,

Line 2794: INTO zx_rates_b_tmp

2790: --BugFix 3605729
2791: IF ID_CLASH = 'Y' THEN
2792: IF L_MULTI_ORG_FLAG = 'Y' THEN
2793: INSERT ALL
2794: INTO zx_rates_b_tmp
2795: (
2796: TAX_RATE_CODE ,
2797: EFFECTIVE_FROM ,
2798: EFFECTIVE_TO ,

Line 3105: INTO zx_rates_b_tmp

3101: where source_id = nvl(p_tax_id,offset.tax_id)
3102: ) ;
3103: ELSE
3104: INSERT ALL
3105: INTO zx_rates_b_tmp
3106: (
3107: TAX_RATE_CODE ,
3108: EFFECTIVE_FROM ,
3109: EFFECTIVE_TO ,

Line 3423: INTO zx_rates_b_tmp

3419: IF L_MULTI_ORG_FLAG = 'Y'
3420: THEN
3421:
3422: INSERT ALL
3423: INTO zx_rates_b_tmp
3424: (
3425: TAX_RATE_CODE ,
3426: EFFECTIVE_FROM ,
3427: EFFECTIVE_TO ,

Line 3734: INTO zx_rates_b_tmp

3730: )
3731: ;
3732: ELSE
3733: INSERT ALL
3734: INTO zx_rates_b_tmp
3735: (
3736: TAX_RATE_CODE ,
3737: EFFECTIVE_FROM ,
3738: EFFECTIVE_TO ,

Line 4144: INTO zx_rates_b_tmp

4140: --BugFix 3605729
4141: IF ID_CLASH = 'Y' THEN
4142: IF L_MULTI_ORG_FLAG = 'Y' THEN
4143: INSERT ALL
4144: INTO zx_rates_b_tmp
4145: (
4146: TAX_RATE_CODE ,
4147: EFFECTIVE_FROM ,
4148: EFFECTIVE_TO ,

Line 4453: INTO zx_rates_b_tmp

4449: ) ;
4450: ELSE
4451:
4452: INSERT ALL
4453: INTO zx_rates_b_tmp
4454: (
4455: TAX_RATE_CODE ,
4456: EFFECTIVE_FROM ,
4457: EFFECTIVE_TO ,

Line 4767: INTO zx_rates_b_tmp

4763:
4764: IF L_MULTI_ORG_FLAG = 'Y'
4765: THEN
4766: INSERT ALL
4767: INTO zx_rates_b_tmp
4768: (
4769: TAX_RATE_CODE ,
4770: EFFECTIVE_FROM ,
4771: EFFECTIVE_TO ,

Line 5078: INTO zx_rates_b_tmp

5074: ;
5075: ELSE
5076:
5077: INSERT ALL
5078: INTO zx_rates_b_tmp
5079: (
5080: TAX_RATE_CODE ,
5081: EFFECTIVE_FROM ,
5082: EFFECTIVE_TO ,

Line 5508: INSERT INTO zx_rates_b_tmp

5504:
5505: )
5506: LOOP
5507: BEGIN
5508: INSERT INTO zx_rates_b_tmp
5509: (
5510: TAX_RATE_CODE ,
5511: EFFECTIVE_FROM ,
5512: EFFECTIVE_TO ,

Line 5654: AND not exists (select 1 from zx_rates_b_tmp

5650: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
5651: AND codes.tax_id = nvl(rates.source_id, rates.tax_rate_id)
5652: AND rates.record_type_code = 'MIGRATED'
5653: AND ROWNUM = 1
5654: AND not exists (select 1 from zx_rates_b_tmp
5655: where SUBSTRB(tax_rate_code,1,24) = substrb(rates.default_rec_rate_code,1,24) --Bug 4943105
5656: and content_owner_id = rates.content_owner_id
5657: and tax_jurisdiction_code = (SELECT tax_id FROM zx_taxes_b WHERE tax_regime_code = rates.tax_regime_code AND tax = rates.tax AND content_owner_id = rates.content_owner_id)
5658: )

Line 5786: INSERT INTO zx_rates_b_tmp

5782:
5783: --For Tax Recovery Rules associated Recovery Rates.
5784: BEGIN
5785:
5786: INSERT INTO zx_rates_b_tmp
5787: (
5788: TAX_RATE_CODE ,
5789: EFFECTIVE_FROM ,
5790: EFFECTIVE_TO ,

Line 5980: INSERT INTO zx_rates_b_tmp

5976: END IF;
5977:
5978: -- For adhoc Recovery Rate creation.
5979: BEGIN
5980: INSERT INTO zx_rates_b_tmp
5981: (
5982: TAX_RATE_CODE ,
5983: EFFECTIVE_FROM ,
5984: EFFECTIVE_TO ,

Line 10445: INTO zx_rates_b_tmp

10441: IF L_MULTI_ORG_FLAG = 'Y'
10442: THEN
10443:
10444: INSERT ALL
10445: INTO zx_rates_b_tmp
10446: (
10447: TAX_RATE_CODE ,
10448: EFFECTIVE_FROM ,
10449: EFFECTIVE_TO ,

Line 10868: INTO zx_rates_b_tmp

10864: ) ;
10865:
10866: ELSE
10867: INSERT ALL
10868: INTO zx_rates_b_tmp
10869: (
10870: TAX_RATE_CODE ,
10871: EFFECTIVE_FROM ,
10872: EFFECTIVE_TO ,

Line 11303: INTO zx_rates_b_tmp

11299: IF L_MULTI_ORG_FLAG = 'Y'
11300: THEN
11301:
11302: INSERT ALL
11303: INTO zx_rates_b_tmp
11304: (
11305: TAX_RATE_CODE ,
11306: EFFECTIVE_FROM ,
11307: EFFECTIVE_TO ,

Line 11728: INTO zx_rates_b_tmp

11724: );
11725: ELSE
11726:
11727: INSERT ALL
11728: INTO zx_rates_b_tmp
11729: (
11730: TAX_RATE_CODE ,
11731: EFFECTIVE_FROM ,
11732: EFFECTIVE_TO ,

Line 12172: INTO zx_rates_b_tmp

12168: IF L_MULTI_ORG_FLAG = 'Y' THEN
12169:
12170: BEGIN
12171: INSERT ALL
12172: INTO zx_rates_b_tmp
12173: (
12174: TAX_RATE_CODE ,
12175: EFFECTIVE_FROM ,
12176: EFFECTIVE_TO ,

Line 12598: INTO zx_rates_b_tmp

12594: END;
12595: ELSE
12596: BEGIN
12597: INSERT ALL
12598: INTO zx_rates_b_tmp
12599: (
12600: TAX_RATE_CODE ,
12601: EFFECTIVE_FROM ,
12602: EFFECTIVE_TO ,

Line 13033: INTO zx_rates_b_tmp

13029: IF L_MULTI_ORG_FLAG = 'Y'
13030: THEN
13031:
13032: INSERT ALL
13033: INTO zx_rates_b_tmp
13034: (
13035: TAX_RATE_CODE ,
13036: EFFECTIVE_FROM ,
13037: EFFECTIVE_TO ,

Line 13458: INTO zx_rates_b_tmp

13454: );
13455: ELSE
13456:
13457: INSERT ALL
13458: INTO zx_rates_b_tmp
13459: (
13460: TAX_RATE_CODE ,
13461: EFFECTIVE_FROM ,
13462: EFFECTIVE_TO ,

Line 13976: update zx_rates_b_tmp rates

13972: /*Stamp the default rate flag correctly for non recovery based rates
13973: Atleast one rate should have this flag set to 'Y' for a given combination
13974: of regime,tax, status and content owner */
13975:
13976: update zx_rates_b_tmp rates
13977: set rates.default_rate_flag = 'Y' ,
13978: rates.default_flg_effective_from = rates.effective_from, --Bug 5104891
13979: rates.default_flg_effective_to = rates.effective_to -- Bug 6680676
13980: where rates.tax_rate_code in ( select rates1.tax_rate_code from zx_rates_b rates1

Line 14006: /* update zx_rates_b_tmp rates

14002: of regime ,tax, status and content owner */
14003:
14004: --Commenting out the logic as it is no longer required
14005: --Bug 5209434
14006: /* update zx_rates_b_tmp rates
14007: set rates.default_rate_flag = 'Y' ,
14008: rates.default_flg_effective_from = rates.effective_from --Bug 5104891
14009: where rates.tax_rate_code in ( select rates1.tax_rate_code from zx_rates_b rates1
14010: where rates.tax_regime_code = rates1.tax_regime_code