DECLARE
V_MONTH_END_DATE date:= '31-jan-2009';
BEGIN

EXECUTE IMMEDIATE 'set autotrace on'; 

   UPDATE bis.dds_issue_fclty
      SET acc_rk =
             (SELECT sf.orig_acc_rk
                FROM rcdwstg.stg_fin_acc sf
               WHERE sf.acc_rk = dds_issue_fclty.acc_rk
                 AND sf.source_system = 'CLASS'
                 AND sf.orig_acc_rk IS NOT NULL),
         update_time = sysdate
    WHERE dds_issue_fclty.source_system = 'PCASAV'
      AND dds_issue_fclty.valid_from_dt = (v_month_end_date)
      AND EXISTS (
             SELECT sf1.orig_acc_rk
               FROM rcdwstg.stg_fin_acc sf1
              WHERE sf1.acc_rk = dds_issue_fclty.acc_rk
                AND sf1.orig_acc_rk IS NOT NULL
                AND sf1.source_system = 'CLASS');

END;

EXECUTE IMMEDIATE ('alter session set sql_trace=true');