APPS.ASG_HELPER dependencies on DBA_OBJECTS

Line 1151: FROM dba_objects

1147: PROCEDURE create_olite_synonyms
1148: IS
1149: CURSOR c_olite_objects IS
1150: SELECT object_name
1151: FROM dba_objects
1152: WHERE owner = 'MOBILEADMIN' AND
1153: object_type in ('TABLE', 'VIEW') AND
1154: object_name not like 'C__$%'
1155: UNION

Line 1157: FROM dba_objects

1153: object_type in ('TABLE', 'VIEW') AND
1154: object_name not like 'C__$%'
1155: UNION
1156: SELECT object_name
1157: FROM dba_objects
1158: WHERE owner = 'MOBILEADMIN' AND
1159: object_type in ('SEQUENCE') AND
1160: object_name not like 'M$%';
1161: l_sql_string VARCHAR2(512);

Line 1181: FROM dba_objects

1177: PROCEDURE drop_olite_synonyms
1178: IS
1179: CURSOR c_olite_objects IS
1180: SELECT object_name
1181: FROM dba_objects
1182: WHERE owner = 'MOBILEADMIN' AND
1183: object_type in ('TABLE', 'VIEW') AND
1184: object_name not like 'C__$%'
1185: UNION

Line 1187: FROM dba_objects

1183: object_type in ('TABLE', 'VIEW') AND
1184: object_name not like 'C__$%'
1185: UNION
1186: SELECT object_name
1187: FROM dba_objects
1188: WHERE owner = 'MOBILEADMIN' AND
1189: object_type in ('SEQUENCE') AND
1190: object_name not like 'M$%';
1191: l_sql_string VARCHAR2(512);