APPS.HZ_PARTY_STAGE dependencies on ALL_INDEXES

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

1043: BEGIN
1044: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
1045: FOR IDX in (
1046: SELECT OWNER||'.'||INDEX_NAME idx_name
1047: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
1048: WHERE f.attribute_id = a.attribute_id
1049: AND i.owner = l_owner1
1050: AND f.index_required_flag in ('Y','T')
1051: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',

Line 11329: SELECT 1 FROM sys.all_indexes

11325: AND f.index_required_flag = 'Y'
11326: AND a.entity_name = p_entity;
11327:
11328: CURSOR check_index(cp_index_name VARCHAR2,cp_table_name VARCHAR2) IS
11329: SELECT 1 FROM sys.all_indexes
11330: WHERE INDEX_NAME=cp_index_name
11331: AND TABLE_NAME=cp_table_name and owner = l_index_owner;
11332:
11333: l_index_name VARCHAR2(255);