APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTY_DEA_VALUES_IDX_DETAILS

Line 86: FROM jty_dea_values_idx_details B

82: AND A.build_index_flag = 'Y';
83:
84: Cursor getDeaFactorList(cl_tvhidpid number) IS
85: SELECT DISTINCT B.VALUES_COL_MAP, B.INPUT_SELECTIVITY
86: FROM jty_dea_values_idx_details B
87: WHERE B.dea_values_idx_header_id = cl_tvhidpid
88: AND B.values_col_map is not null
89: ORDER BY input_selectivity;
90:

Line 2367: DELETE jty_dea_values_idx_details dtl

2363:
2364: RAISE FND_API.G_EXC_ERROR;
2365: END IF;
2366:
2367: DELETE jty_dea_values_idx_details dtl
2368: WHERE EXISTS (
2369: SELECT 1
2370: FROM jty_dea_values_idx_header hdr
2371: WHERE dtl.dea_values_idx_header_id = hdr.dea_values_idx_header_id