APPS.ZX_VALID_INIT_PARAMS_PKG dependencies on ZX_REVERSE_TRX_LINES_GT

Line 2048: SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */

2044:
2045: x_return_status := FND_API.G_RET_STS_SUCCESS;
2046:
2047: BEGIN
2048: SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */
2049: hdrgt.legal_entity_id ,
2050: hdrgt.internal_organization_id,
2051: zl.related_doc_date,
2052: zl.adjusted_doc_date,

Line 2070: ZX_REVERSE_TRX_LINES_GT lngt,

2066: l_entity_code,
2067: l_event_class_code,
2068: l_trx_id
2069: FROM ZX_REV_TRX_HEADERS_GT hdrgt,
2070: ZX_REVERSE_TRX_LINES_GT lngt,
2071: ZX_LINES_DET_FACTORS zl
2072: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
2073: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
2074: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code

Line 2113: SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */

2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112: END IF;
2113: SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */
2114: hdrgt.legal_entity_id ,
2115: hdrgt .internal_organization_id,
2116: zl.related_doc_date,
2117: zl.adjusted_doc_date,

Line 2135: ZX_REVERSE_TRX_LINES_GT lngt,

2131: l_entity_code,
2132: l_event_class_code,
2133: l_trx_id
2134: FROM ZX_REV_TRX_HEADERS_GT hdrgt,
2135: ZX_REVERSE_TRX_LINES_GT lngt,
2136: ZX_LINES_DET_FACTORS zl
2137: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
2138: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
2139: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code