APPS.HR_EFC_INFO dependencies on USER_SYNONYMS

Line 1460: , user_synonyms syn

1456: CURSOR csr_get_efc_tables IS
1457: SELECT distinct tab.table_name
1458: FROM all_tables tab
1459: , all_tab_columns col
1460: , user_synonyms syn
1461: WHERE ((tab.table_name like '%_EFC'
1462: AND tab.table_name <> 'PAY_BALANCE_TYPES_EFC'
1463: AND tab.table_name <> 'PAY_ORG_PAYMENT_METHODS_F_EFC'
1464: AND hr_general.hrms_object(tab.table_name) = 'TRUE')

Line 1579: , user_synonyms syn

1575: SELECT tab.column_name,
1576: tab.data_type,
1577: tab.data_length
1578: FROM all_tab_columns tab
1579: , user_synonyms syn
1580: WHERE tab.table_name = c_name
1581: AND tab.table_name = syn.synonym_name
1582: AND tab.owner = syn.table_owner;
1583: --