APPS.FEM_WEBADI_FEM_BAL_UTILS_PVT dependencies on FEM_TAB_COLUMN_PROP

Line 286: select fcp.column_name column_name from fem_tab_column_prop fcp

282:
283: begin
284:
285: select 'Y' into x_error_flag from dual where exists(
286: select fcp.column_name column_name from fem_tab_column_prop fcp
287: where fcp.table_name = 'FEM_BALANCES'
288: and fcp.column_property_code = 'PROCESSING_KEY'
289: and fcp.column_name not in
290: ('CREATED_BY_REQUEST_ID',

Line 408: and column_name in (select ftc.interface_column_name interface_column_name from fem_tab_columns_b ftc,fem_tab_column_prop fcp

404: for key_recs in
405: (select table_name,column_name,data_type,nullable from dba_tab_columns
406: where owner = 'FEM'
407: and table_name = 'FEM_BAL_INTERFACE_T'
408: and column_name in (select ftc.interface_column_name interface_column_name from fem_tab_columns_b ftc,fem_tab_column_prop fcp
409: where ftc.table_name = fcp.table_name
410: and ftc.column_name = fcp.column_name
411: and ftc.table_name = 'FEM_BALANCES'
412: and fcp.column_property_code = 'PROCESSING_KEY'