APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTY_TERR_VALUES_IDX_DETAILS

Line 72: FROM jty_terr_values_idx_details B

68: ORDER BY A.index_name;
69:
70: Cursor getFactorList(cl_tvhidpid number) IS
71: SELECT DISTINCT B.VALUES_COL_MAP, B.INPUT_SELECTIVITY
72: FROM jty_terr_values_idx_details B
73: WHERE B.terr_values_idx_header_id = cl_tvhidpid
74: AND B.values_col_map is not null
75: ORDER BY input_selectivity;
76:

Line 262: DELETE jty_terr_values_idx_details dtl

258:
259: END LOOP;
260:
261: IF (p_mode = 'INCREMENTAL') THEN
262: DELETE jty_terr_values_idx_details dtl
263: WHERE EXISTS (
264: SELECT 1
265: FROM jty_terr_values_idx_header hdr
266: WHERE dtl.terr_values_idx_header_id = hdr.terr_values_idx_header_id

Line 2333: DELETE jty_terr_values_idx_details dtl

2329:
2330: RAISE FND_API.G_EXC_ERROR;
2331: END IF;
2332:
2333: DELETE jty_terr_values_idx_details dtl
2334: WHERE EXISTS (
2335: SELECT 1
2336: FROM jty_terr_values_idx_header hdr
2337: WHERE dtl.terr_values_idx_header_id = hdr.terr_values_idx_header_id