APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on USER_OBJECTS

Line 921: FROM user_tab_columns t , user_objects o

917: (SELECT xem.column_name column_name
918: ,xem.column_title PROMPT
919: ,utc.data_type data_type
920: FROM (SELECT t.table_name , t.column_name ,t.data_type
921: FROM user_tab_columns t , user_objects o
922: WHERE t.table_name = o.object_name
923: AND o.object_name = l_event_class_set(k).reporting_view_name
924: AND o.object_type <> 'SYNONYM'
925: UNION ALL

Line 930: FROM user_synonyms s , user_objects o

926: SELECT dt.table_name, dt.column_name , dt.data_type
927: FROM dba_tab_columns dt
928: WHERE (dt.table_name , dt.owner)
929: IN ( SELECT s.table_name , s.table_owner
930: FROM user_synonyms s , user_objects o
931: WHERE 1 = 1
932: AND o.object_name = l_event_class_set(k).reporting_view_name
933: AND o.object_type = 'SYNONYM'
934: AND s.synonym_name = o.object_name ) ) utc,