execute_query;

DECLARE 
    finalstr     VARCHAR2(5000); 
    dfinalstr    VARCHAR2(5000); 
    CURSOR c1 
    IS 
     SELECT DISTINCT id
                FROM xxc_history 
               WHERE name = :block.name
                 AND trunc(creation_date) BETWEEN :block.date_from AND :block.date_to;

BEGIN 
    FOR c_rec IN c1 LOOP 
        IF c_rec.id IS NOT NULL THEN 
          v_id := c_rec.id; 
              finalstr := 'WHERE 1=1'; 
              finalstr := finalstr ||' AND id  = ' ||v_id; 
              Go_block('xxc_DETAILS'); 

              dfinalstr := Get_block_property('xxc_DETAILS', default_where ); 

              Set_block_property('xxc_DETAILS', default_where, finalstr) ; 

              Execute_query(); 

        END IF; 
     END LOOP; 
END;