[Home] [Help]
195:
196: -- need to find out NOCOPY the table involved for the data points
197: CURSOR c_dnb_source_table IS
198: SELECT distinct source_table_name
199: FROM ar_cmgt_dnb_elements_vl
200: WHERE source_table_name <> 'HZ_FINANCIAL_NUMBERS' -- this table is accessed via hz_financial_reports
201: and data_element_id in (
202: SELECT data_element_id
203: FROM ar_cmgt_dnb_mappings