APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTY_TERR_VALUES_IDX_DETAILS

Line 479: FROM jty_terr_values_idx_details A,

475: NULL dev,
476: A.INPUT_ORDINAL_SELECTIVITY ord_sele,
477: A.INPUT_SELECTIVITY sele,
478: 1 flag
479: FROM jty_terr_values_idx_details A,
480: jty_terr_values_idx_header B
481: WHERE A.VALUES_COL_MAP is not null
482: AND B.delete_flag = 'N'
483: AND A.terr_values_idx_header_id = B.terr_values_idx_header_id

Line 588: UPDATE jty_terr_values_idx_details

584: WHERE VALUES_COL_MAP = col_name(i);
585: END LOOP;
586: ELSE
587: FOR i IN 1..col_name.count LOOP
588: UPDATE jty_terr_values_idx_details
589: SET INPUT_SELECTIVITY = i,
590: INPUT_ORDINAL_SELECTIVITY = o_sel(i)
591: WHERE VALUES_COL_MAP = col_name(i);
592: END LOOP;