APPS.ZX_API_PUB dependencies on ZX_DETAIL_TAX_LINES_GT

Line 237: FROM zx_detail_tax_lines_gt

233: END IF;
234: BEGIN
235: SELECT sync_with_prvdr_flag
236: INTO l_sync_with_prvdr_flag
237: FROM zx_detail_tax_lines_gt
238: WHERE application_id = p_event_class_rec.application_id
239: AND entity_code = p_event_class_rec.entity_code
240: AND event_class_code = p_event_class_rec.event_class_code
241: AND trx_id = p_event_class_rec.trx_id

Line 1084: zx_detail_tax_lines_gt TaxLines

1080: trx_level_type,
1081: trx_line_id,
1082: sum(tax_amt) incl_tax_amt
1083: FROM
1084: zx_detail_tax_lines_gt TaxLines
1085: WHERE
1086: tax_amt_included_flag = 'Y'
1087: -- AND mrc_tax_line_flag = 'N'
1088: AND cancel_flag <> 'Y'

Line 1318: -- need to flush ZX_DETAIL_TAX_LINES_GT before the procedure

1314: */
1315: -- bug fix 5417887 end
1316:
1317: -- bug#6594730
1318: -- need to flush ZX_DETAIL_TAX_LINES_GT before the procedure
1319: -- calculate_tax_pvt is called for the next event class
1320:
1321: IF l_record_tax_lines = 'Y' THEN
1322: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

Line 1322: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

1318: -- need to flush ZX_DETAIL_TAX_LINES_GT before the procedure
1319: -- calculate_tax_pvt is called for the next event class
1320:
1321: IF l_record_tax_lines = 'Y' THEN
1322: DELETE FROM ZX_DETAIL_TAX_LINES_GT;
1323: END IF;
1324:
1325: -- bug 6824850
1326: ZX_GLOBAL_STRUCTURES_PKG.PTNR_TAX_REGIME_TBL.DELETE;

Line 2017: zx_detail_tax_lines_gt TaxLines

2013: trx_level_type,
2014: trx_line_id,
2015: sum(tax_amt) incl_tax_amt
2016: FROM
2017: zx_detail_tax_lines_gt TaxLines
2018: WHERE
2019: tax_amt_included_flag = 'Y'
2020: -- AND mrc_tax_line_flag = 'N'
2021: AND cancel_flag <> 'Y'

Line 2707: -- need to flush ZX_DETAIL_TAX_LINES_GT before the procedure

2703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2704: END IF;
2705:
2706: -- bug#6389189
2707: -- need to flush ZX_DETAIL_TAX_LINES_GT before the procedure
2708: -- import_tax_pvt is called for the next event class
2709:
2710: -- Bug fix 7506576 Included additional condition flag quote_flag when
2711: -- deleting records from GT TABLES

Line 2716: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

2712:
2713: --IF zx_global_structures_pkg.g_event_class_rec.record_flag = 'Y' AND ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec.quote_flag = 'N'
2714: -- Reimplemented the fix done in bug#7506576
2715: IF l_record_tax_lines = 'Y' THEN
2716: DELETE FROM ZX_DETAIL_TAX_LINES_GT;
2717: END IF;
2718:
2719:
2720: /*******************************PARTNER CODE START****************************/