APPS.XLA_EXTRACT_INTEGRITY_PKG dependencies on USER_SYNONYMS

Line 1453: FROM user_synonyms syn

1449:
1450: CURSOR c_syn_owner
1451: IS
1452: SELECT syn.table_owner
1453: FROM user_synonyms syn
1454: WHERE syn.synonym_name = l_object_name;
1455:
1456: BEGIN
1457:

Line 1551: ,user_synonyms syn

1547: ,owner)
1548: SELECT ext.object_name
1549: ,(SELECT syn.table_owner
1550: FROM user_objects usr
1551: ,user_synonyms syn
1552: WHERE ext.object_name = usr.object_name
1553: AND usr.object_name = syn.synonym_name
1554: AND usr.object_type = 'SYNONYM')
1555: FROM xla_extract_objects ext

Line 1558: ,user_synonyms syn

1554: AND usr.object_type = 'SYNONYM')
1555: FROM xla_extract_objects ext
1556: WHERE EXISTS (SELECT /*+ no_unnest */ 'c'
1557: FROM user_objects usr
1558: ,user_synonyms syn
1559: WHERE ext.object_name = usr.object_name
1560: AND usr.object_name = syn.synonym_name
1561: AND usr.object_type = 'SYNONYM')
1562: AND ext.application_id = p_application_id

Line 1575: ,user_synonyms syn

1571: ,owner)
1572: SELECT rfr.reference_object_name
1573: ,(SELECT syn.table_owner
1574: FROM user_objects usr
1575: ,user_synonyms syn
1576: -- change rfr.object_name to rfr.reference_object_name, as told by dimple
1577: WHERE rfr.reference_object_name = usr.object_name
1578: AND usr.object_name = syn.synonym_name
1579: AND usr.object_type = 'SYNONYM')

Line 1583: ,user_synonyms syn

1579: AND usr.object_type = 'SYNONYM')
1580: FROM xla_reference_objects rfr
1581: WHERE EXISTS (SELECT /*+ no_unnest */ 'c'
1582: FROM user_objects usr
1583: ,user_synonyms syn
1584: -- change rfr.object_name to rfr.reference_object_name, as told by dimple
1585: WHERE rfr.reference_object_name = usr.object_name
1586: AND usr.object_name = syn.synonym_name
1587: AND usr.object_type = 'SYNONYM')