APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTY_DEA_VALUES_IDX_DETAILS

Line 516: FROM jty_dea_values_idx_details A,

512: NULL dev,
513: A.INPUT_ORDINAL_SELECTIVITY ord_sele,
514: A.INPUT_SELECTIVITY sele,
515: 1 flag
516: FROM jty_dea_values_idx_details A,
517: jty_dea_values_idx_header B
518: WHERE A.VALUES_COL_MAP is not null
519: AND A.dea_values_idx_header_id = B.dea_values_idx_header_id
520: AND B.source_id = cl_source_id;

Line 610: UPDATE jty_dea_values_idx_details

606: END LOOP;
607: ELSE
608: IF (p_mode = 'DATE EFFECTIVE') THEN
609: FOR i IN 1..col_name.count LOOP
610: UPDATE jty_dea_values_idx_details
611: SET INPUT_SELECTIVITY = i,
612: INPUT_ORDINAL_SELECTIVITY = o_sel(i)
613: WHERE VALUES_COL_MAP = col_name(i);
614: END LOOP;