1454: --
1455: -- Cursor to find _efc tables
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'