APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTY_DEA_VALUES_IDX_HEADER

Line 80: FROM jty_dea_values_idx_header A

76:
77: Cursor getDeaProductList(cl_source_id number) IS
78: SELECT A.dea_values_idx_header_id,
79: A.index_name
80: FROM jty_dea_values_idx_header A
81: WHERE A.source_id = p_source_id
82: AND A.build_index_flag = 'Y';
83:
84: Cursor getDeaFactorList(cl_tvhidpid number) IS

Line 312: UPDATE jty_dea_values_idx_header

308: alter_statement := 'ALTER INDEX ' || l_ora_username || '.' || prd.index_name || ' NOPARALLEL';
309: EXECUTE IMMEDIATE alter_statement;
310: EXCEPTION
311: WHEN duplicate_index THEN /* Catch Duplicate Index Creation Exception */
312: UPDATE jty_dea_values_idx_header
313: SET BUILD_INDEX_FLAG = 'N'
314: WHERE dea_values_idx_header_id = prd.dea_values_idx_header_id;
315: END;
316: END IF; /* end IF (j > 1) */

Line 2370: FROM jty_dea_values_idx_header hdr

2366:
2367: DELETE jty_dea_values_idx_details dtl
2368: WHERE EXISTS (
2369: SELECT 1
2370: FROM jty_dea_values_idx_header hdr
2371: WHERE dtl.dea_values_idx_header_id = hdr.dea_values_idx_header_id
2372: AND hdr.source_id = p_source_id );
2373:
2374: DELETE jty_dea_values_idx_header hdr

Line 2374: DELETE jty_dea_values_idx_header hdr

2370: FROM jty_dea_values_idx_header hdr
2371: WHERE dtl.dea_values_idx_header_id = hdr.dea_values_idx_header_id
2372: AND hdr.source_id = p_source_id );
2373:
2374: DELETE jty_dea_values_idx_header hdr
2375: WHERE hdr.source_id = p_source_id;
2376:
2377: EXECUTE IMMEDIATE 'delete ' || l_table_name || ' where source_id = :1 ' USING p_source_id;
2378: ELSIF (p_mode = 'INCREMENTAL') THEN