APPS.MSD_SRP_SSL_RS dependencies on ALL_INDEXES

Line 21: select count(1) from ALL_INDEXES

17: l_req_id number;
18:
19: CURSOR c_check_ui (p_unique_index_name VARCHAR2)
20: IS
21: select count(1) from ALL_INDEXES
22: where owner = owner
23: and index_name = p_unique_index_name;
24:
25: CURSOR c_get_ui (p_unique_index_name VARCHAR2)

Line 27: select owner from ALL_INDEXES

23: and index_name = p_unique_index_name;
24:
25: CURSOR c_get_ui (p_unique_index_name VARCHAR2)
26: IS
27: select owner from ALL_INDEXES
28: where owner = owner
29: and index_name = p_unique_index_name;
30:
31: C_DR_UI VARCHAR2(50) := 'MSD_DEM_DPT_REP_USG_HIST_U1';