DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_REGIMES_B

Line 115: FROM ZX_REGIMES_B

111: INTO x_migrated_tax_regime_id
112: , x_migrated_effective_from -- Bug 5557565
113: , x_migrated_effective_to -- Bug 5557565
114: , x_migrated_country_code
115: FROM ZX_REGIMES_B
116: WHERE tax_regime_code = x_migrated_tax_regime_code;
117: END IF; --- bug6024643
118: END IF;
119:

Line 216: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;

212: ) IS
213: l_api_name CONSTANT VARCHAR2(30) := 'SET_DETAIL_TAX_LINE_VALUES';
214: l_count NUMBER;
215:
216: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;
217: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
218:
219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;

Line 217: l_tax_regime_id zx_regimes_b.tax_regime_id%type;

213: l_api_name CONSTANT VARCHAR2(30) := 'SET_DETAIL_TAX_LINE_VALUES';
214: l_count NUMBER;
215:
216: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;
217: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
218:
219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;

Line 401: FROM zx_regimes_b

397: OR prev_tax_regime_code <> ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(p_ptnr_tax_line_ind) THEN
398: BEGIN
399: SELECT tax_regime_id
400: INTO l_tax_regime_id
401: FROM zx_regimes_b
402: WHERE tax_regime_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(p_ptnr_tax_line_ind);
403: END;
404: prev_tax_regime_code := ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(p_ptnr_tax_line_ind);
405: END IF;

Line 786: l_migrated_country_code ZX_REGIMES_B.country_code%TYPE;

782: l_migrated_effective_from DATE;
783: l_migrated_effective_to DATE;
784: l_return_status VARCHAR2(1);
785: l_tax_regime_id NUMBER;
786: l_migrated_country_code ZX_REGIMES_B.country_code%TYPE;
787: l_context_info_rec ZX_API_PUB.context_info_rec_type;
788:
789: /* Bug 5557565 */
790:

Line 799: , zx_regimes_b regimes

795: regimes.effective_from,
796: regimes.effective_to,
797: regimes.country_code
798: FROM ZX_TRX_LINE_APP_REGIMES ztlar
799: , zx_regimes_b regimes
800: WHERE ztlar.application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(l_index)
801: AND ztlar.entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(l_index)
802: AND ztlar.event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(l_index)
803: AND ztlar.trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(l_index)

Line 816: , zx_regimes_b regimes

812: regimes.effective_from,
813: regimes.effective_to,
814: regimes.country_code
815: FROM ZX_TRX_LINE_APP_REGIMES ztlar
816: , zx_regimes_b regimes
817: WHERE ztlar.application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(l_index)
818: AND ztlar.entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(l_index)
819: AND ztlar.event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(l_index)
820: AND ztlar.trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(l_index)

Line 2091: c_tax ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

2087: -- Bug#5417753
2088: --
2089: CURSOR get_def_tax_rate_csr
2090: (c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2091: c_tax ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2092: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2093: c_tax_class ZX_RATES_B.TAX_CLASS%TYPE,
2094: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)
2095: IS

Line 2092: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

2088: --
2089: CURSOR get_def_tax_rate_csr
2090: (c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2091: c_tax ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2092: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2093: c_tax_class ZX_RATES_B.TAX_CLASS%TYPE,
2094: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)
2095: IS
2096: SELECT rate.tax_rate_code,