APPS.FEM_SOURCE_DATA_LOADER_PKG dependencies on ALL_TAB_COLUMNS

Line 53: target_nullable ALL_TAB_COLUMNS.nullable%TYPE);

49: TYPE proc_keys_info_rec_type IS RECORD
50: (
51: target_col FEM_TAB_COLUMNS_V.column_name%TYPE,
52: interface_col FEM_TAB_COLUMNS_V.interface_column_name%TYPE,
53: target_nullable ALL_TAB_COLUMNS.nullable%TYPE);
54:
55: TYPE g_proc_keys_info_type IS TABLE OF proc_keys_info_rec_type INDEX BY BINARY_INTEGER;
56: g_proc_keys_tbl g_proc_keys_info_type;
57: g_proc_key_dim_num NUMBER;

Line 1703: FROM fem_tab_columns_b ftc, all_tab_columns atc, fem_tab_column_prop tcp

1699:
1700: BEGIN
1701: SELECT ftc.column_name, ftc.interface_column_name, atc.nullable
1702: BULK COLLECT INTO g_proc_keys_tbl
1703: FROM fem_tab_columns_b ftc, all_tab_columns atc, fem_tab_column_prop tcp
1704: WHERE atc.table_name = l_db_tab_name
1705: AND atc.owner = l_tab_owner
1706: AND ftc.table_name = p_target_table_name
1707: AND atc.column_name = ftc.column_name