APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on FEM_TABLES_B

Line 288: select interface_table_name into l_interface_table from fem_tables_b

284: l_interface_code := p_table_name || '_INTF';
285:
286: ------------------------ populating maping for corresponding interface table params
287: begin
288: select interface_table_name into l_interface_table from fem_tables_b
289: where table_name = p_table_name;
290: exception
291: when NO_DATA_FOUND then null;
292: end;

Line 1086: where interface_table_name = (select interface_table_name from fem_tables_b where table_name = p_table_name)

1082:
1083: for extra_params in
1084: (
1085: select bne_interface_col_name from fem_webadi_table_cols_maps
1086: where interface_table_name = (select interface_table_name from fem_tables_b where table_name = p_table_name)
1087: and bne_interface_col_name not in(select interface_col_name from
1088: bne_interface_cols_b where interface_code = l_interface_code)
1089: )
1090: loop

Line 1313: fem_tables_b where table_name = l_table_name;

1309:
1310: begin
1311:
1312: select interface_table_name into l_interface_table_name from
1313: fem_tables_b where table_name = l_table_name;
1314:
1315: --------- First populating bne_interface_cols ( 'delete insert' those records for which we have info in fem_tab_columns_b table
1316:
1317: ------------------------------- For bne_interface_cols_b

Line 2797: select interface_table_name into l_intf_table_name from fem_tables_b

2793: l_intf_table_name varchar2(50);
2794: begin
2795:
2796: begin
2797: select interface_table_name into l_intf_table_name from fem_tables_b
2798: where table_name = p_table_name;
2799:
2800: select count(1) into l_total_columns from dba_tab_columns
2801: where owner = (select table_owner from user_synonyms where synonym_name = l_intf_table_name)