APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on JTY_DEA_VALUES_IDX_DETAILS

Line 493: FROM jty_dea_values_idx_details A,

489: NULL dev,
490: A.INPUT_ORDINAL_SELECTIVITY ord_sele,
491: A.INPUT_SELECTIVITY sele,
492: 1 flag
493: FROM jty_dea_values_idx_details A,
494: jty_dea_values_idx_header B
495: WHERE A.VALUES_COL_MAP is not null
496: AND A.dea_values_idx_header_id = B.dea_values_idx_header_id
497: AND B.source_id = cl_source_id;

Line 581: UPDATE jty_dea_values_idx_details

577: END LOOP;
578: ELSE
579: IF (p_mode = 'DATE EFFECTIVE') THEN
580: FOR i IN 1..col_name.count LOOP
581: UPDATE jty_dea_values_idx_details
582: SET INPUT_SELECTIVITY = i,
583: INPUT_ORDINAL_SELECTIVITY = o_sel(i)
584: WHERE VALUES_COL_MAP = col_name(i);
585: END LOOP;