APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTY_TERR_VALUES_IDX_DETAILS

Line 84: FROM jty_terr_values_idx_details B

80: ORDER BY A.index_name;
81:
82: Cursor getFactorList(cl_tvhidpid number) IS
83: SELECT DISTINCT B.VALUES_COL_MAP, B.INPUT_SELECTIVITY
84: FROM jty_terr_values_idx_details B
85: WHERE B.terr_values_idx_header_id = cl_tvhidpid
86: AND B.values_col_map is not null
87: ORDER BY input_selectivity;
88:

Line 285: DELETE jty_terr_values_idx_details dtl

281:
282: END LOOP;
283:
284: IF (p_mode = 'INCREMENTAL') THEN
285: DELETE jty_terr_values_idx_details dtl
286: WHERE EXISTS (
287: SELECT 1
288: FROM jty_terr_values_idx_header hdr
289: WHERE dtl.terr_values_idx_header_id = hdr.terr_values_idx_header_id

Line 2462: DELETE jty_terr_values_idx_details dtl

2458:
2459: RAISE FND_API.G_EXC_ERROR;
2460: END IF;
2461:
2462: DELETE jty_terr_values_idx_details dtl
2463: WHERE EXISTS (
2464: SELECT 1
2465: FROM jty_terr_values_idx_header hdr
2466: WHERE dtl.terr_values_idx_header_id = hdr.terr_values_idx_header_id