APPS.HZ_PARTY_STAGE dependencies on ALL_INDEXES

Line 1059: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f

1055: BEGIN
1056: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
1057: FOR IDX in (
1058: SELECT OWNER||'.'||INDEX_NAME idx_name
1059: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
1060: WHERE f.attribute_id = a.attribute_id
1061: AND i.owner = l_owner1
1062: AND f.index_required_flag in ('Y','T')
1063: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',

Line 11483: SELECT 1 FROM sys.all_indexes

11479: AND f.index_required_flag = 'Y'
11480: AND a.entity_name = p_entity;
11481:
11482: CURSOR check_index(cp_index_name VARCHAR2,cp_table_name VARCHAR2) IS
11483: SELECT 1 FROM sys.all_indexes
11484: WHERE INDEX_NAME=cp_index_name
11485: AND TABLE_NAME=cp_table_name and owner = l_index_owner;
11486:
11487: l_index_name VARCHAR2(255);