16: -- Cursor to retrieve the schema name
17: --
18: cursor csr_user is
19: select oracle_username
20: from fnd_oracle_userid
21: where oracle_id = 800;
22: --
23: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null ;
24: BEGIN
19: select oracle_username
20: from fnd_oracle_userid
21: where oracle_id = 800;
22: --
23: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null ;
24: BEGIN
25: --
26: if (g_index_name is null) then
27: open csr_user;