DECLARE
--initialize variables here 
    v_date varchar2(10); 
    v_rebuild_index   varchar2(250); 
    v_sql   VARCHAR2(250);
    p_table_name varchar2(250) := 'DS_ABSENCE';
    p_source_table varchar2(30) := 'STG_ABSENCE';
    p_source_owner varchar2(30)  := 'STG_SAP';
    v_for_sql varchar2(1000);
-- main body 
BEGIN 
       
     v_for_sql := 'select TO_CHAR(MIN(a.calendar_date),''YYYY-MM-DD'') start_date_of_period 
                            FROM ' || p_source_owner||'.'||p_source_table ||' a, conformed_dimension.dim_calendar b 
                            WHERE a.calendar_date = b.calendar_date 
                            GROUP BY b.start_date_of_period';
        
                     
     FOR cur_period IN (v_for_sql) LOOP 
         
        v_date := cur_period.start_date_of_period; 
        
        v_sql := 'DELETE FROM '|| p_table_name || ' WHERE calendar_date = ' ||v_date; 
                  
         dbms_output.put_line (v_sql); 
                
        --EXECUTE IMMEDIATE v_sql; 

        END LOOP;  

END;
/