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_TL

Line 975: | ZX_RATES_TL |

971: | DESCRIPTION |
972: | This routine processes AP normal Tax codes and inserts appropriate |
973: | data into the following zx base tables. |
974: | ZX_RATES_B |
975: | ZX_RATES_TL |
976: | ZX_ACCOUNTS |
977: | |
978: | SCOPE - PUBLIC |
979: | |

Line 2703: INSERT INTO ZX_RATES_TL

2699:
2700: end if;
2701:
2702:
2703: INSERT INTO ZX_RATES_TL
2704: (
2705: TAX_RATE_ID,
2706: TAX_RATE_NAME,
2707: CREATED_BY,

Line 2745: from ZX_RATES_TL T

2741: AND avtb.tax_id = RATES.tax_rate_id
2742: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
2743: AND not exists
2744: (select NULL
2745: from ZX_RATES_TL T
2746: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
2747: and T.LANGUAGE = L.LANGUAGE_CODE);
2748:
2749: IF PG_DEBUG = 'Y' THEN

Line 2776: | ZX_RATES_TL |

2772: | DESCRIPTION |
2773: | This routine processes assigned OFFSET Tax codes and inserts |
2774: | appropriate data into the following zx base tables. |
2775: | ZX_RATES_B |
2776: | ZX_RATES_TL |
2777: | ZX_ACCOUNTS |
2778: | |
2779: | SCOPE - PUBLIC |
2780: | |

Line 4071: INSERT INTO ZX_RATES_TL

4067:
4068: END IF;
4069:
4070:
4071: INSERT INTO ZX_RATES_TL
4072: (
4073: TAX_RATE_ID,
4074: TAX_RATE_NAME,
4075: CREATED_BY,

Line 4107: from ZX_RATES_TL T

4103: AND avtb.tax_id = RATES.tax_rate_id
4104: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
4105: AND not exists
4106: (select NULL
4107: from ZX_RATES_TL T
4108: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
4109: and T.LANGUAGE = L.LANGUAGE_CODE);
4110:
4111: IF PG_DEBUG = 'Y' THEN

Line 4135: | ZX_RATES_TL |

4131: | DESCRIPTION |
4132: | This routine processes unassigned OFFSET Tax codes and inserts |
4133: | appropriate data into the following zx base tables. |
4134: | ZX_RATES_B |
4135: | ZX_RATES_TL |
4136: | ZX_ACCOUNTS |
4137: | |
4138: | SCOPE - PUBLIC |
4139: | |

Line 5420: INSERT INTO ZX_RATES_TL

5416: ;
5417: END IF;
5418:
5419:
5420: INSERT INTO ZX_RATES_TL
5421: (
5422: TAX_RATE_ID,
5423: TAX_RATE_NAME,
5424: CREATED_BY,

Line 5456: from ZX_RATES_TL T

5452: AND avtb.tax_id = RATES.tax_rate_id
5453: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
5454: AND not exists
5455: (select NULL
5456: from ZX_RATES_TL T
5457: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
5458: and T.LANGUAGE = L.LANGUAGE_CODE);
5459:
5460: IF PG_DEBUG = 'Y' THEN

Line 5483: | ZX_RATES_TL |

5479: | DESCRIPTION |
5480: | This routine processes distinct recovery rates,inserts appropriate |
5481: | data into the following zx base tables. |
5482: | ZX_RATES_B |
5483: | ZX_RATES_TL |
5484: | ZX_ACCOUNTS |
5485: | |
5486: | SCOPE - PUBLIC |
5487: | |

Line 5723: INSERT INTO ZX_RATES_TL

5719: end;
5720:
5721: -- No need to insert into ZX_ACCOUNTS for Recovery rates.
5722: BEGIN
5723: INSERT INTO ZX_RATES_TL
5724: (
5725: TAX_RATE_ID,
5726: TAX_RATE_NAME,
5727: CREATED_BY,

Line 5760: from ZX_RATES_TL T

5756: AND avtb.tax_id = RATES.tax_rate_id
5757: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
5758: AND not exists
5759: (select NULL
5760: from ZX_RATES_TL T
5761: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
5762: and T.LANGUAGE = L.LANGUAGE_CODE);
5763: EXCEPTION WHEN OTHERS THEN
5764: NULL;

Line 5789: | ZX_RATES_TL |

5785: | DESCRIPTION |
5786: | This routine processes distinct recovery rates,inserts appropriate |
5787: | data into the following zx base tables. |
5788: | ZX_RATES_B |
5789: | ZX_RATES_TL |
5790: | ZX_ACCOUNTS |
5791: | |
5792: | SCOPE - PUBLIC |
5793: | |

Line 5988: | ZX_RATES_TL |

5984: | This routine creates an adhoc recovery rate with tax_rate_code |
5985: | starting with AD_HOC_RECOVERY for each tax for which tax recovery |
5986: | is allowed and populates the following ZX base tables. |
5987: | ZX_RATES_B |
5988: | ZX_RATES_TL |
5989: | SCOPE - PRIVATE |
5990: | |
5991: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
5992: | |

Line 6144: -- inserting into ZX_RATES_TL

6140: arp_util_tax.debug(sqlerrm);
6141: END IF;
6142: END;
6143:
6144: -- inserting into ZX_RATES_TL
6145:
6146: INSERT INTO ZX_RATES_TL
6147: (
6148: TAX_RATE_ID,

Line 6146: INSERT INTO ZX_RATES_TL

6142: END;
6143:
6144: -- inserting into ZX_RATES_TL
6145:
6146: INSERT INTO ZX_RATES_TL
6147: (
6148: TAX_RATE_ID,
6149: TAX_RATE_NAME,
6150: CREATED_BY,

Line 6179: from ZX_RATES_TL T

6175: L.INSTALLED_FLAG in ('I', 'B')
6176: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
6177: AND not exists
6178: (select NULL
6179: from ZX_RATES_TL T
6180: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
6181: and T.LANGUAGE = L.LANGUAGE_CODE);
6182:
6183: IF PG_DEBUG = 'Y' THEN

Line 14216: INSERT INTO ZX_RATES_TL

14212: with no date overlap'||sqlerrm);
14213: END;
14214:
14215:
14216: INSERT INTO ZX_RATES_TL
14217: (
14218: TAX_RATE_ID,
14219: TAX_RATE_NAME,
14220: CREATED_BY,

Line 14253: from ZX_RATES_TL T

14249: AND avtb.tax_id = RATES.tax_rate_id
14250: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
14251: AND not exists
14252: (select NULL
14253: from ZX_RATES_TL T
14254: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
14255: and T.LANGUAGE = L.LANGUAGE_CODE);
14256:
14257: IF PG_DEBUG = 'Y' THEN