APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTY_DEA_VALUES_IDX_DETAILS

Line 98: FROM jty_dea_values_idx_details B

94: AND A.build_index_flag = 'Y';
95:
96: Cursor getDeaFactorList(cl_tvhidpid number) IS
97: SELECT DISTINCT B.VALUES_COL_MAP, B.INPUT_SELECTIVITY
98: FROM jty_dea_values_idx_details B
99: WHERE B.dea_values_idx_header_id = cl_tvhidpid
100: AND B.values_col_map is not null
101: ORDER BY input_selectivity;
102:

Line 363: DELETE jty_dea_values_idx_details dtl

359:
360: END LOOP;
361:
362: IF (p_mode = 'DEA INCREMENTAL') THEN
363: DELETE jty_dea_values_idx_details dtl
364: WHERE EXISTS (
365: SELECT 1
366: FROM jty_dea_values_idx_header hdr
367: WHERE dtl.dea_values_idx_header_id = hdr.dea_values_idx_header_id

Line 2494: DELETE jty_dea_values_idx_details dtl

2490:
2491: RAISE FND_API.G_EXC_ERROR;
2492: END IF;
2493:
2494: DELETE jty_dea_values_idx_details dtl
2495: WHERE EXISTS (
2496: SELECT 1
2497: FROM jty_dea_values_idx_header hdr
2498: WHERE dtl.dea_values_idx_header_id = hdr.dea_values_idx_header_id