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 1072: zx_detail_tax_lines_gt TaxLines

1068: trx_level_type,
1069: trx_line_id,
1070: sum(tax_amt) incl_tax_amt
1071: FROM
1072: zx_detail_tax_lines_gt TaxLines
1073: WHERE
1074: tax_amt_included_flag = 'Y'
1075: -- AND mrc_tax_line_flag = 'N'
1076: AND cancel_flag <> 'Y'

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

1295: */
1296: -- bug fix 5417887 end
1297:
1298: -- bug#6594730
1299: -- need to flush ZX_DETAIL_TAX_LINES_GT before the procedure
1300: -- calculate_tax_pvt is called for the next event class
1301:
1302: IF l_record_tax_lines = 'Y' THEN
1303: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

Line 1303: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

1299: -- need to flush ZX_DETAIL_TAX_LINES_GT before the procedure
1300: -- calculate_tax_pvt is called for the next event class
1301:
1302: IF l_record_tax_lines = 'Y' THEN
1303: DELETE FROM ZX_DETAIL_TAX_LINES_GT;
1304: END IF;
1305:
1306: -- bug 6824850
1307: ZX_GLOBAL_STRUCTURES_PKG.PTNR_TAX_REGIME_TBL.DELETE;

Line 1863: zx_detail_tax_lines_gt TaxLines

1859: trx_level_type,
1860: trx_line_id,
1861: sum(tax_amt) incl_tax_amt
1862: FROM
1863: zx_detail_tax_lines_gt TaxLines
1864: WHERE
1865: tax_amt_included_flag = 'Y'
1866: -- AND mrc_tax_line_flag = 'N'
1867: AND cancel_flag <> 'Y'

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

2419: RETURN;
2420: END IF;
2421:
2422: -- bug#6389189
2423: -- need to flush ZX_DETAIL_TAX_LINES_GT before the procedure
2424: -- import_tax_pvt is called for the next event class
2425:
2426: -- Bug fix 7506576 Included additional condition flag quote_flag when
2427: -- deleting records from GT TABLES

Line 2432: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

2428:
2429: --IF zx_global_structures_pkg.g_event_class_rec.record_flag = 'Y' AND ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec.quote_flag = 'N'
2430: -- Reimplemented the fix done in bug#7506576
2431: IF l_record_tax_lines = 'Y' THEN
2432: DELETE FROM ZX_DETAIL_TAX_LINES_GT;
2433: END IF;
2434:
2435:
2436: /*******************************PARTNER CODE START****************************/