APPS.FEM_ADMIN_UTIL_PKG dependencies on ALL_IND_COLUMNS

Line 1344: FROM all_ind_columns i, fem_tab_columns_b c

1340: -- have a direct mapping (CAL_PERIOD_ID) or no mapping at all
1341: -- (Undo WHO columns).
1342: SELECT count(*)
1343: INTO v_count
1344: FROM all_ind_columns i, fem_tab_columns_b c
1345: WHERE i.index_name = idx.index_name
1346: AND i.table_owner = v_int_owner
1347: AND i.table_name = v_int_db_tab_name
1348: AND c.table_name = p_tab_name

Line 1382: FROM all_ind_columns i, fem_tab_columns_b c

1378: 'CREATED_BY_OBJECT_ID',
1379: 'LAST_UPDATED_BY_OBJECT_ID')
1380: AND column_name NOT IN
1381: (SELECT c.column_name
1382: FROM all_ind_columns i, fem_tab_columns_b c
1383: WHERE i.index_name = idx.index_name
1384: AND i.table_owner = v_int_owner
1385: AND i.table_name = v_int_db_tab_name
1386: AND c.table_name = p_tab_name

Line 1411: FROM all_ind_columns i

1407:
1408: IF v_count > 0 THEN
1409: SELECT count(*)
1410: INTO v_count
1411: FROM all_ind_columns i
1412: WHERE i.index_name = idx.index_name
1413: AND i.table_owner = v_int_owner
1414: AND i.table_name = v_int_db_tab_name
1415: AND i.column_name IN ('CAL_PERIOD_NUMBER',

Line 1911: FROM all_ind_columns

1907:
1908: -- Then make sure the Proc Key metadata matches with the index
1909: SELECT count(*)
1910: INTO v_count
1911: FROM all_ind_columns
1912: WHERE index_owner = v_idx_owner
1913: AND index_name = v_idx_name
1914: AND table_owner = p_tab_owner
1915: AND table_name = p_db_tab_name

Line 1934: FROM all_ind_columns

1930: WHERE table_name = p_tab_name
1931: AND column_property_code = 'PROCESSING_KEY'
1932: AND column_name NOT IN
1933: (SELECT column_name
1934: FROM all_ind_columns
1935: WHERE index_owner = v_idx_owner
1936: AND index_name = v_idx_name
1937: AND table_owner = p_tab_owner
1938: AND table_name = p_db_tab_name);