APPS.ZX_VALID_INIT_PARAMS_PKG dependencies on ZX_REVERSE_TRX_LINES_GT

Line 2021: 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) */

2017:
2018: x_return_status := FND_API.G_RET_STS_SUCCESS;
2019:
2020: BEGIN
2021: 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) */
2022: hdrgt.legal_entity_id ,
2023: hdrgt.internal_organization_id,
2024: zl.related_doc_date,
2025: zl.adjusted_doc_date,

Line 2043: ZX_REVERSE_TRX_LINES_GT lngt,

2039: l_entity_code,
2040: l_event_class_code,
2041: l_trx_id
2042: FROM ZX_REV_TRX_HEADERS_GT hdrgt,
2043: ZX_REVERSE_TRX_LINES_GT lngt,
2044: ZX_LINES_DET_FACTORS zl
2045: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
2046: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
2047: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code

Line 2086: 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) */

2082: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END IF;
2085: END IF;
2086: 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) */
2087: hdrgt.legal_entity_id ,
2088: hdrgt .internal_organization_id,
2089: zl.related_doc_date,
2090: zl.adjusted_doc_date,

Line 2108: ZX_REVERSE_TRX_LINES_GT lngt,

2104: l_entity_code,
2105: l_event_class_code,
2106: l_trx_id
2107: FROM ZX_REV_TRX_HEADERS_GT hdrgt,
2108: ZX_REVERSE_TRX_LINES_GT lngt,
2109: ZX_LINES_DET_FACTORS zl
2110: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
2111: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
2112: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code