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_TDS_IMPORT_DOCUMENT_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

Line 990: SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

986: p_tax_point_date IN DATE,
987: x_return_status OUT NOCOPY VARCHAR2) IS
988:
989: CURSOR get_imported_det_tax_lines_csr IS
990: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
991: *
992: FROM zx_detail_tax_lines_gt
993: WHERE application_id =p_event_class_rec.application_id
994: AND entity_code =p_event_class_rec.entity_code

Line 992: FROM zx_detail_tax_lines_gt

988:
989: CURSOR get_imported_det_tax_lines_csr IS
990: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
991: *
992: FROM zx_detail_tax_lines_gt
993: WHERE application_id =p_event_class_rec.application_id
994: AND entity_code =p_event_class_rec.entity_code
995: AND event_class_code =p_event_class_rec.event_class_code
996: AND trx_id = p_event_class_rec.trx_id

Line 1260: -- delete the pulled-in tax lines from zx_detail_tax_lines_gt

1256: IF l_begin_index IS NOT NULL THEN
1257:
1258: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
1259:
1260: -- delete the pulled-in tax lines from zx_detail_tax_lines_gt
1261: --
1262: DELETE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1263: FROM zx_detail_tax_lines_gt
1264: WHERE application_id =p_event_class_rec.application_id

Line 1262: DELETE /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

1258: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
1259:
1260: -- delete the pulled-in tax lines from zx_detail_tax_lines_gt
1261: --
1262: DELETE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1263: FROM zx_detail_tax_lines_gt
1264: WHERE application_id =p_event_class_rec.application_id
1265: AND entity_code =p_event_class_rec.entity_code
1266: AND event_class_code =p_event_class_rec.event_class_code

Line 1263: FROM zx_detail_tax_lines_gt

1259:
1260: -- delete the pulled-in tax lines from zx_detail_tax_lines_gt
1261: --
1262: DELETE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1263: FROM zx_detail_tax_lines_gt
1264: WHERE application_id =p_event_class_rec.application_id
1265: AND entity_code =p_event_class_rec.entity_code
1266: AND event_class_code =p_event_class_rec.event_class_code
1267: AND trx_id = p_event_class_rec.trx_id