create or replace
 PROCEDURE BULK_REJECT(System_name VARCHAR2)
 as
 MDM_run_id VARCHAR2(14);
 V_sql clob;
 cursor Job_metric is 
select rowid_job,system_name, table_display_name, run_status
 from c_repos_job_control where trunc(last_update_date) = trunc(sysdate-2)
 and object_function_type_code in ('C','L') and run_status in (0,1) order by system_name desc;

 metric job_metric%ROWTYPE;

 BEGIN 

select max(run_id) into MDM_run_id from memc_etl_run;
 open job_metric;
 loop fetch Job_metric into metric;
 exit when job_metric%NOTFOUND;

 
V_sql:= 'insert into TARGET_CUSTOM_REJECT_BO
 select '||MDM_run_id||',
 b.pkey_src_object,''mdm_err'',a.error_description,'||metric.system_name||',''ui''
 from c_stg_sfa_party_rej a ,C_stg_sfa_party b 
where
 trunc(a.src_rowid)=trunc(b.src_rowid) 
and a.rowid_job='''||metric.rowid_job||'''';
 EXECUTE IMMEDIATE V_sql;
 end loop;
 commit;
 close job_metric;
 end BULK_reject;//

//Connecting to the database cmx_ors.
ORA-00904: "SFA": invalid identifier
ORA-06512: at "CMX_ORS.BULK_REJECT", line 27
ORA-06512: at line 6
Process exited.
Disconnecting from the database cmx_ors.//

...
    Insert Into Target_Custom_Reject_Bo( run_id, src_pkey, err_cd, err_attr, srs_sys_cd, mapng_nm)
    Select mdm_run_id
         , b.pkey_src_object
         , 'mdm_err'
         , a.error_description
         , metric.system_name
         , 'ui'
    from   c_stg_sfa_party_rej a 
       ,   c_stg_sfa_party     b 
    Where trunc(a.src_rowid) = trunc(b.src_rowid) 
    and   a.rowid_job        = metric.rowid_job;
...