APPS.ASG_HELPER dependencies on DBA_OBJECTS

Line 1214: FROM dba_objects

1210: PROCEDURE create_olite_synonyms
1211: IS
1212: CURSOR c_olite_objects IS
1213: SELECT object_name
1214: FROM dba_objects
1215: WHERE owner = 'MOBILEADMIN' AND
1216: object_type in ('TABLE', 'VIEW') AND
1217: object_name not like 'C__$%'
1218: UNION

Line 1220: FROM dba_objects

1216: object_type in ('TABLE', 'VIEW') AND
1217: object_name not like 'C__$%'
1218: UNION
1219: SELECT object_name
1220: FROM dba_objects
1221: WHERE owner = 'MOBILEADMIN' AND
1222: object_type in ('SEQUENCE') AND
1223: object_name not like 'M$%';
1224: l_sql_string VARCHAR2(512);

Line 1244: FROM dba_objects

1240: PROCEDURE drop_olite_synonyms
1241: IS
1242: CURSOR c_olite_objects IS
1243: SELECT object_name
1244: FROM dba_objects
1245: WHERE owner = 'MOBILEADMIN' AND
1246: object_type in ('TABLE', 'VIEW') AND
1247: object_name not like 'C__$%'
1248: UNION

Line 1250: FROM dba_objects

1246: object_type in ('TABLE', 'VIEW') AND
1247: object_name not like 'C__$%'
1248: UNION
1249: SELECT object_name
1250: FROM dba_objects
1251: WHERE owner = 'MOBILEADMIN' AND
1252: object_type in ('SEQUENCE') AND
1253: object_name not like 'M$%';
1254: l_sql_string VARCHAR2(512);