APPS.HR_EFC_INFO dependencies on ALL_TAB_COLUMNS

Line 1459: , all_tab_columns col

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'
1463: AND tab.table_name <> 'PAY_ORG_PAYMENT_METHODS_F_EFC'

Line 1564: -- definitions for that table in ALL_TAB_COLUMNS.

1560: -- ----------------------------------------------------------------------------
1561: --
1562: -- Description:
1563: -- Determines the size of a row, for a given table, by looking at the column
1564: -- definitions for that table in ALL_TAB_COLUMNS.
1565: -- Criteria for estimation are:
1566: -- - If the column is VARCHAR2, and a currency column, size is 3 bytes
1567: -- - If the column is VARCHAR2, size is (length of column)/3 bytes.
1568: -- - If the column type is NUMBER, size is (length of column)/2 bytes.

Line 1578: FROM all_tab_columns tab

1574: CURSOR csr_find_details(c_name IN varchar2) IS
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;