APPS.ZX_NEW_SERVICES_PKG dependencies on ZX_TRANSACTION_LINES_GT

Line 54: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */

50: /* Cursor for updating Det Factors information during Cancel/Discard */
51: Cursor c_lines(p_event_class_rec ZX_API_PUB.event_class_rec_type,
52: p_trx_line_id NUMBER,
53: p_trx_level_type VARCHAR2) is
54: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */
55: header.INTERNAL_ORGANIZATION_ID ,
56: header.APPLICATION_ID ,
57: header.ENTITY_CODE ,
58: header.EVENT_CLASS_CODE ,

Line 412: FROM ZX_TRANSACTION_LINES_GT trxlines,

408: 'SYNCHRONIZE','U',
409: 'DELETE','U') INSERT_UPDATE_FLAG
410: /* The update insert flag is to determine the records that need to be inserted/updated
411: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
412: FROM ZX_TRANSACTION_LINES_GT trxlines,
413: ZX_TRX_HEADERS_GT header
414: WHERE trxlines.application_id = header.application_id
415: AND trxlines.entity_code = header.entity_code
416: AND trxlines.event_class_code = header.event_class_code