198: u.oracle_id = i.oracle_id;
199:
200: CURSOR c_synonyms (pc_synonym_name IN VARCHAR2) IS
201: SELECT COUNT(*) count
202: FROM user_synonyms
203: WHERE synonym_name = pc_synonym_name;
204:
205: CURSOR c_attribute1_refresh IS
206: SELECT COUNT(*) count
878: u.oracle_id = i.oracle_id;
879:
880: CURSOR c_synonyms (pc_synonym_name IN VARCHAR2) IS
881: SELECT COUNT(*) count
882: FROM user_synonyms
883: WHERE synonym_name = pc_synonym_name;
884:
885: -- -----------------------------------------------------------------------
886: -- Local Variables