APPS.HR_INDEX_CHECK dependencies on ALL_INDEXES

Line 44: from all_indexes

40: cursor csr_find_ben_indexes (c_per_owner in varchar2,
41: c_ben_owner in varchar2) is
42: select table_name,
43: index_name
44: from all_indexes
45: where table_name like 'BEN_%'
46: and index_name not like 'SYS_%'
47: and ((owner = c_per_owner) or
48: (owner = c_ben_owner))

Line 54: from all_indexes

50: --
51: cursor csr_find_per_indexes (c_per_owner in varchar2) is
52: select table_name,
53: index_name
54: from all_indexes
55: where ((table_name like 'PER_%') or
56: ((table_name like 'HR_%') and
57: (table_name not like 'HRI_%')))
58: and index_name not like 'SYS_%'

Line 65: from all_indexes

61: --
62: cursor csr_find_hri_indexes (c_owner in varchar2) is
63: select table_name,
64: index_name
65: from all_indexes
66: where ((table_name like 'HR_EDW%') or
67: (table_name like 'HRI_%'))
68: and index_name not like 'SYS_%'
69: and owner = c_owner

Line 76: from all_indexes

72: cursor csr_find_indexes(c_prod in varchar2,
73: c_owner in varchar2) is
74: select table_name,
75: index_name
76: from all_indexes
77: where table_name like c_prod
78: and index_name not like 'SYS_%'
79: and owner = c_owner
80: order by table_name, index_name;

Line 517: from all_indexes

513: CURSOR csr_find_ben_indexes (c_per_owner in varchar2,
514: c_ben_owner in varchar2) IS
515: select table_name,
516: index_name
517: from all_indexes
518: where table_name like 'BEN_%'
519: and index_name not like 'SYS_%'
520: and index_name like '%FK%'
521: and ((owner = c_per_owner) or

Line 528: from all_indexes

524: --
525: CURSOR csr_find_per_indexes (c_per_owner in varchar2) IS
526: select table_name,
527: index_name
528: from all_indexes
529: where ((table_name like 'PER_%') or
530: ((table_name like 'HR_%') and
531: (table_name not like 'HRI_%')))
532: and index_name not like 'SYS_%'

Line 540: from all_indexes

536: --
537: CURSOR csr_find_hri_indexes (c_owner in varchar2) IS
538: select table_name,
539: index_name
540: from all_indexes
541: where ((table_name like 'HRI_%') or
542: (table_name like 'HRI_EDW%'))
543: and index_name not like 'SYS_%'
544: and index_name like '%FK%'

Line 552: from all_indexes

548: CURSOR csr_find_indexes(c_prod in varchar2,
549: c_owner in varchar2) IS
550: select table_name,
551: index_name
552: from all_indexes
553: where table_name like c_prod
554: and index_name not like 'SYS_%'
555: and index_name like '%FK%'
556: and owner = c_owner