APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_RATES_TL

Line 956: | ZX_RATES_TL |

952: | DESCRIPTION |
953: | This routine processes AP normal Tax codes and inserts appropriate |
954: | data into the following zx base tables. |
955: | ZX_RATES_B |
956: | ZX_RATES_TL |
957: | ZX_ACCOUNTS |
958: | |
959: | SCOPE - PUBLIC |
960: | |

Line 2694: INSERT INTO ZX_RATES_TL

2690:
2691: end if;
2692:
2693:
2694: INSERT INTO ZX_RATES_TL
2695: (
2696: TAX_RATE_ID,
2697: TAX_RATE_NAME,
2698: CREATED_BY,

Line 2731: from ZX_RATES_TL T

2727: AND avtb.vat_tax_id = RATES.tax_rate_id
2728: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
2729: AND not exists
2730: (select NULL
2731: from ZX_RATES_TL T
2732: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
2733: and T.LANGUAGE = L.LANGUAGE_CODE);
2734:
2735: IF PG_DEBUG = 'Y' THEN

Line 2762: | ZX_RATES_TL |

2758: | DESCRIPTION |
2759: | This routine processes assigned OFFSET Tax codes and inserts |
2760: | appropriate data into the following zx base tables. |
2761: | ZX_RATES_B |
2762: | ZX_RATES_TL |
2763: | ZX_ACCOUNTS |
2764: | |
2765: | SCOPE - PUBLIC |
2766: | |

Line 4049: INSERT INTO ZX_RATES_TL

4045:
4046: END IF;
4047:
4048:
4049: INSERT INTO ZX_RATES_TL
4050: (
4051: TAX_RATE_ID,
4052: TAX_RATE_NAME,
4053: CREATED_BY,

Line 4085: from ZX_RATES_TL T

4081: AND avtb.vat_tax_id = RATES.tax_rate_id
4082: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
4083: AND not exists
4084: (select NULL
4085: from ZX_RATES_TL T
4086: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
4087: and T.LANGUAGE = L.LANGUAGE_CODE);
4088:
4089: IF PG_DEBUG = 'Y' THEN

Line 4113: | ZX_RATES_TL |

4109: | DESCRIPTION |
4110: | This routine processes unassigned OFFSET Tax codes and inserts |
4111: | appropriate data into the following zx base tables. |
4112: | ZX_RATES_B |
4113: | ZX_RATES_TL |
4114: | ZX_ACCOUNTS |
4115: | |
4116: | SCOPE - PUBLIC |
4117: | |

Line 5390: INSERT INTO ZX_RATES_TL

5386: ;
5387: END IF;
5388:
5389:
5390: INSERT INTO ZX_RATES_TL
5391: (
5392: TAX_RATE_ID,
5393: TAX_RATE_NAME,
5394: CREATED_BY,

Line 5426: from ZX_RATES_TL T

5422: AND avtb.vat_tax_id = RATES.tax_rate_id
5423: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
5424: AND not exists
5425: (select NULL
5426: from ZX_RATES_TL T
5427: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
5428: and T.LANGUAGE = L.LANGUAGE_CODE);
5429:
5430: IF PG_DEBUG = 'Y' THEN

Line 5453: | ZX_RATES_TL |

5449: | DESCRIPTION |
5450: | This routine processes distinct recovery rates,inserts appropriate |
5451: | data into the following zx base tables. |
5452: | ZX_RATES_B |
5453: | ZX_RATES_TL |
5454: | ZX_ACCOUNTS |
5455: | |
5456: | SCOPE - PUBLIC |
5457: | |

Line 5692: INSERT INTO ZX_RATES_TL

5688: end;
5689:
5690: -- No need to insert into ZX_ACCOUNTS for Recovery rates.
5691: BEGIN
5692: INSERT INTO ZX_RATES_TL
5693: (
5694: TAX_RATE_ID,
5695: TAX_RATE_NAME,
5696: CREATED_BY,

Line 5729: from ZX_RATES_TL T

5725: AND avtb.vat_tax_id = RATES.tax_rate_id
5726: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
5727: AND not exists
5728: (select NULL
5729: from ZX_RATES_TL T
5730: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
5731: and T.LANGUAGE = L.LANGUAGE_CODE);
5732: EXCEPTION WHEN OTHERS THEN
5733: NULL;

Line 5758: | ZX_RATES_TL |

5754: | DESCRIPTION |
5755: | This routine processes distinct recovery rates,inserts appropriate |
5756: | data into the following zx base tables. |
5757: | ZX_RATES_B |
5758: | ZX_RATES_TL |
5759: | ZX_ACCOUNTS |
5760: | |
5761: | SCOPE - PUBLIC |
5762: | |

Line 5957: | ZX_RATES_TL |

5953: | This routine creates an adhoc recovery rate with tax_rate_code |
5954: | starting with AD_HOC_RECOVERY for each tax for which tax recovery |
5955: | is allowed and populates the following ZX base tables. |
5956: | ZX_RATES_B |
5957: | ZX_RATES_TL |
5958: | SCOPE - PRIVATE |
5959: | |
5960: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
5961: | |

Line 6113: -- inserting into ZX_RATES_TL

6109: arp_util_tax.debug(sqlerrm);
6110: END IF;
6111: END;
6112:
6113: -- inserting into ZX_RATES_TL
6114:
6115: INSERT INTO ZX_RATES_TL
6116: (
6117: TAX_RATE_ID,

Line 6115: INSERT INTO ZX_RATES_TL

6111: END;
6112:
6113: -- inserting into ZX_RATES_TL
6114:
6115: INSERT INTO ZX_RATES_TL
6116: (
6117: TAX_RATE_ID,
6118: TAX_RATE_NAME,
6119: CREATED_BY,

Line 6148: from ZX_RATES_TL T

6144: L.INSTALLED_FLAG in ('I', 'B')
6145: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
6146: AND not exists
6147: (select NULL
6148: from ZX_RATES_TL T
6149: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
6150: and T.LANGUAGE = L.LANGUAGE_CODE);
6151:
6152: IF PG_DEBUG = 'Y' THEN

Line 13891: INSERT INTO ZX_RATES_TL

13887: with no date overlap'||sqlerrm);
13888: END;
13889:
13890:
13891: INSERT INTO ZX_RATES_TL
13892: (
13893: TAX_RATE_ID,
13894: TAX_RATE_NAME,
13895: CREATED_BY,

Line 13928: from ZX_RATES_TL T

13924: AND avtb.vat_tax_id = RATES.tax_rate_id
13925: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
13926: AND not exists
13927: (select NULL
13928: from ZX_RATES_TL T
13929: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
13930: and T.LANGUAGE = L.LANGUAGE_CODE);
13931:
13932: IF PG_DEBUG = 'Y' THEN