DBA Data[Home] [Help]

APPS.FEM_GL_POST_PROCESS_PKG dependencies on FEM_TAB_COLUMNS_B

Line 1151: -- DIMENSION_ID from FEM_TAB_COLUMNS_B instead of from

1147: -- handling logic for being called by Process_Data_Slice.
1148: -- 06-02-04 G Hall Bug# 3603260: Changed FEM_DISPLAY_CODE_COL_MAP to
1149: -- FEM_INT_COLUMN_MAP per design changes for this table.
1150: -- 01-28-05 G Hall Bug# 4148677: Changed main query to get the
1151: -- DIMENSION_ID from FEM_TAB_COLUMNS_B instead of from
1152: -- FEM_COLUMN_REQUIREMNT_B.
1153: -- Arguments
1154: -- p_process_slice A character string concatenation of the MP FW
1155: -- subrequest process number and the data slice id

Line 1187: fem_tab_columns_b tc,

1183: cm.interface_column_name,
1184: xd.attribute_table_name
1185: BULK COLLECT INTO pv_proc_keys
1186: FROM fem_tab_column_prop tcp,
1187: fem_tab_columns_b tc,
1188: fem_xdim_dimensions xd,
1189: fem_int_column_map cm
1190: WHERE tcp.table_name = 'FEM_BALANCES'
1191: AND tcp.column_property_code = 'PROCESSING_KEY'

Line 5144: , fem_tab_columns_b tc

5140: AND r.dimension_id <> 0
5141: AND r.dimension_id NOT IN
5142: (SELECT tc.dimension_id
5143: FROM fem_tab_column_prop tcp
5144: , fem_tab_columns_b tc
5145: WHERE tcp.table_name = 'FEM_BALANCES'
5146: AND tcp.column_property_code = 'PROCESSING_KEY'
5147: AND tc.table_name = 'FEM_BALANCES'
5148: AND tc.column_name = tcp.column_name)