APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTY_TERR_VALUES_IDX_DETAILS

Line 502: FROM jty_terr_values_idx_details A,

498: NULL dev,
499: A.INPUT_ORDINAL_SELECTIVITY ord_sele,
500: A.INPUT_SELECTIVITY sele,
501: 1 flag
502: FROM jty_terr_values_idx_details A,
503: jty_terr_values_idx_header B
504: WHERE A.VALUES_COL_MAP is not null
505: AND B.delete_flag = 'N'
506: AND A.terr_values_idx_header_id = B.terr_values_idx_header_id

Line 617: UPDATE jty_terr_values_idx_details

613: WHERE VALUES_COL_MAP = col_name(i);
614: END LOOP;
615: ELSE
616: FOR i IN 1..col_name.count LOOP
617: UPDATE jty_terr_values_idx_details
618: SET INPUT_SELECTIVITY = i,
619: INPUT_ORDINAL_SELECTIVITY = o_sel(i)
620: WHERE VALUES_COL_MAP = col_name(i);
621: END LOOP;