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 915: SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

911: p_tax_point_date IN DATE,
912: x_return_status OUT NOCOPY VARCHAR2) IS
913:
914: CURSOR get_imported_det_tax_lines_csr IS
915: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
916: *
917: FROM zx_detail_tax_lines_gt
918: WHERE application_id =p_event_class_rec.application_id
919: AND entity_code =p_event_class_rec.entity_code

Line 917: FROM zx_detail_tax_lines_gt

913:
914: CURSOR get_imported_det_tax_lines_csr IS
915: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
916: *
917: FROM zx_detail_tax_lines_gt
918: WHERE application_id =p_event_class_rec.application_id
919: AND entity_code =p_event_class_rec.entity_code
920: AND event_class_code =p_event_class_rec.event_class_code
921: AND trx_id = p_event_class_rec.trx_id

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

1122: IF l_begin_index IS NOT NULL THEN
1123:
1124: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
1125:
1126: -- delete the pulled-in tax lines from zx_detail_tax_lines_gt
1127: --
1128: DELETE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1129: FROM zx_detail_tax_lines_gt
1130: WHERE application_id =p_event_class_rec.application_id

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

1124: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
1125:
1126: -- delete the pulled-in tax lines from zx_detail_tax_lines_gt
1127: --
1128: DELETE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1129: FROM zx_detail_tax_lines_gt
1130: WHERE application_id =p_event_class_rec.application_id
1131: AND entity_code =p_event_class_rec.entity_code
1132: AND event_class_code =p_event_class_rec.event_class_code

Line 1129: FROM zx_detail_tax_lines_gt

1125:
1126: -- delete the pulled-in tax lines from zx_detail_tax_lines_gt
1127: --
1128: DELETE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1129: FROM zx_detail_tax_lines_gt
1130: WHERE application_id =p_event_class_rec.application_id
1131: AND entity_code =p_event_class_rec.entity_code
1132: AND event_class_code =p_event_class_rec.event_class_code
1133: AND trx_id = p_event_class_rec.trx_id